Archer electronics company actual sales and purchases

Assignment Help Accounting Basics
Reference no: EM131077039

Archer Electronics Company's actual sales and purchases for April and May are shown here, along with forecasted sales and purchases for June through September. Sales Purchases April (actual) $ 370,000 $ 155,000 May (actual) 350,000 145,000 June (forecast) 325,000 145,000 July (forecast) 325,000 205,000 August (forecast) 340,000 225,000 September (forecast) 380,000 220,000. The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale, and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after. Labor expense equals 15 percent of the current month's sales.

Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in June and September. There is a scheduled capital outlay of $350,000 in September. Archer Electronics' ending cash balance in May is $22,500.

The minimum desired cash balance is $10,500. Prepare a schedule of monthly cash receipts for June through September. Prepare a schedule of monthly cash payments for June through September. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (less than $10,500).

Reference no: EM131077039

Questions Cloud

Natural style of writing for most people : This essay explores the narrative mode, which is perhaps the most natural style of writing for most people. The narrative form has much in common with fiction or creative writing, in that it relies on descriptive language, dialogue, and dramatic a..
Table or chart listing product-price-place : You will analyze the 4 P's for your brand (VictoriaBeckham). Again, the 4 P's was in the reading material (price, product, place, promotion). This can be completed on a table or chart listing product, price, place (online, brick, other, both), and..
Is there a gap in the knowledge that you can fill : A desire to ‘know' more, a passion for a field of study and the motivation to do something for the ‘greater  good' are important for researchers to enjoy and gain satisfaction from their work. Consider this scenario - Does something pique y..
Concerning the sharing of that knowledge : Q1: What steps were taken to consolidate and safeguard the knowledge gained during execution of the Project;  that is, to benefit from "lessons learned?" Q2: What decisions were made concerning the sharing of that knowledge?
Archer electronics company actual sales and purchases : Archer Electronics Company's actual sales and purchases for April and May are shown here, along with forecasted sales and purchases for June through September.
Analyze the key influences that the theoretical aspects : From the weekly readings and e-Activity, predict two to three (2-3) challenges that public leaders will face regarding the future of public leadership. Provide a rationale for your response
Benefits and outcomes of international strategy : Why would companies choose to venture out of their home country? Include the benefits and outcomes of international strategy for a company in your response. Companies may select different modes of entry into the international markets. Discuss some..
What are the five racial groups defined by the act : Are race and color distinctions mutually exclusive under the Civil Rights Act of 1964? Can two persons be of the same race but of different colors under the act? What are the five racial groups defined by the act?
Discuss the different kinds of mobile and wearable devices : The team should get together and discuss the different kinds of mobile and wearable devices (at least two, preferably three or more), research the features and functionality of them, and compare them based on five criteria.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Equivalent production schedule

Medical laboratories. Inc. produces an antibiotic product in its three producing departments. The following quantitative and cost data have been made available.

  Vincent pays 20000 for equipment to use n his trade or

vincent pays 20000 for equipment to use n his trade or business. he pays sales tax of 800 as a result of the purchase.

  Why would an entity choose to use eva over the concept of

why would an entity choose to use eva over the concept of roi for purposes of evaluating the financial performance of

  Getting a sample mean problem

The average cost of a one bedroom apartment in a town is $550 per month. What is the probability of randomly selecting a sample of 50 one bedroom apartments in this town and getting a sample mean of less then $530 if the population standard deviat..

  A patent held by holister having a 12500 book value was

alison inc. paid 83400 for a 40 percent interest in holister corporations common stock. this investee had assets with a

  Unearned revenues rent on december

Unearned revenues rent. On December 1, 2013, an advance rent payment of $12,900, representing a three month prepayment for the months of December, January, and February, was received in cash from the company's tenant.

  Problem regarding the chain of command

Consider the following statements: Computer technology has made the concept of: 1. authority more relevant 2. authority less relevant 3. chain of command more relevant 4. unity of command less relevant Which of the statements given above is/are co..

  Universal foods sold the entire bond issue described

Prepare the journal entry to record the purchase of the bonds by Wang Communications on January 1, 2011.

  How much is cost of goods manufactured

How much is cost of goods manufactured. Is this necessarily the same as cost of goods sold. Why or why not

  Rand medical manufactures lithotripters lithotripsy uses

rand medical manufactures lithotripters. lithotripsy uses shock waves instead of surgery to eliminate kidney stones.

  Crede inc has two divisions division a makes and sells

crede inc. has two divisions. division a makes and sells student desks. division b manufactures and sells reading

  Development structured for possible transition

Deadlines are made and the motion to encourage is put into place. Some of these things are elements of what management embraces to prepare for change and the ability to adapt by their employees.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd