Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: April (actual) May (actual) June (forecast) July (forecast) August (forecast) September (forecast) Sales $ 370,000 350,000 325,000 325,000 340,000 380,000 Purchases $ 155,000 145,000 145,000 205,000 225,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.

Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: April (actual) May (actual) June (forecast) July (forecast) August (forecast) September (forecast) Sales $ 370,000 350,000 325,000 325,000 340,000 380,000 Purchases $ 155,000 145,000 145,000 205,000 225,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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The trailer company exspects to sell 9000 for $155 each for a total of $1,395,000 in January and 4500 units for $225 each for a total of $1,012,500 in February. The company exspects the cost of goods sold to average 70% of sales revenue, and the company exspects to sell 4700 units in march for $290 each. Trailer's target ending inventory is $9000 plus 50% of next months cost of goods sold. Prepare Trailer's inventory, purchases, and cost of goods sold budget for January and February. Trailer Company Inventory, Purchases, and Cost of Goods Sold Budget Two months Ended January 31 and February 28 January february cost of goods sold Plus: Desired ending merchandise inventory Total merchandise inventory required Less: Beginning merchandise inventory Budgeted purchases
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $74,000 in June, $68,000 in July, and $88,000 in August? Cash collected $fill in the blank 1
MNO Company forecast sales in units for July to November as follows: Units JULY - 4000 aUGUST - 4300 SEPTEMBER - 4500 OCTOBER - 4700 NOVEMBER - 5000 MNO Company would like to maintain 200 units in its ending inventory at the end of each month starting July. Ending inventory for the month of June is 150 units. Beginning inventory at the start of January amounts to 100 units. 1. How many units should MNO Company produce for the month of July to fulfill the expected sales of the company?
Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March April May June July August $ 42,000 48,000 37,000 46,000 54,000 56,000 Sales in January and February were $45,000 and $44,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Credit sales Collections: In month of sale One month after sale Watt's Lighting Stores Cash Receipts Schedule January February March April May June July August Two months after sale $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total cash receipts
ABC Company manufactures and sells lighting fixtures. Estimated sales for the next three months are; September – $350,000 October – $500,000 November – $400,000 Sales for August were $400,000. All sales are on account, ABC Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for ABC Company.
Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 12,000 June $ 14,000 April 16,000 July 17,000 May 10,000 August 18,000 Sales in January and February were $13, 500 and $13,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a. Prepare a monthly cash receipts schedule for the firm for March through August. Ed's Waterbeds Cash Receipts Schedule January February March April May June July August Sales $ $ $ $ $ $ $ $ Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ $ $ $ $$b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? Amount…
FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box Direct material required per 100 boxes: Paperboard ($0.30 per pound) Corrugating medium ($0.15 per pound). Direct labor required per 100 boxes ($18.00 per hour). Indirect material Indirect labor Utilities Property taxes Insurance Depreciation. Total C $12,150 95,850 31,500 21,000 16,000. 33,500 $210,000 Total 40 pounds 30 pounds 0.25 hour The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 400,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours. The following selling and administrative expenses are anticipated for the next year. Salaries and fringe benefits of sales personnel. Advertising $115,500 23,500…
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $520,000 for April, $530,000 for May, and $555,000 for June. Total sales for March are $292,100. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from Cash sales Accounts payable Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 520,000 May 530,000 June 555,000
The table contains the Sales estimates for the next year. The Purchases are 55% of Sales. Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan 87,400 July 21,931 Feb 89,751 Aug 78,038 Mar 78,038 Sep 87,400 Apr 21,931 Oct 78,038 May 87,400 Nov 89,751 June 89,751 Dec 21,931
Trailers Company expects to sell 6,500 units for $155 each for a total of $1,007,500 in January and 2,300 units for $200 each for a total of $460,000 in February. The company expécts cost of goods sold to average 50% of sales revenue, and the company expects to sell 5,000 units in March for $200 each. Trailers' target ending inventory is $20,000 plus 50% of the next month's cost of goods sold. Prepare Trailers' inventory, purchases, and cost of goods sold budget for January and February. Trailers Company Inventory, Purchases, and Cost of Goods Sold Budget Two months Ended January 31 and February 28 January Cost of goods sold Plus: Desired ending merchandise inventory Total merchandise inventory required Less: Beginning merchandise inventory Budgeted purchases 503750 135000 638750 February 230000 520000 750000
amm.01
Earthie's Shoes has 55% of its sales in cash and the remaining 45% are credit sales. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?