January 1,100 May 1,6501,800FebruaryMarchApril950 June900 July1,5001,400Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December(January's beginning inventory) is 1,430 units, which is consistent with this policy.Materials cost $12 per unit and are paid for in the month after production. Labour cost is $5 per unit and is paid in the month the cost isincurred. Overhead costs are $7,500 per month. Interest of $8,300 is scheduled to be paid in March, and employee bonuses of$13,500 will be paid in June,a. Prepare a monthly production schedule for January through June. (Enter all values as positive value.)Ace Battery CompanyProduction ScheduleForecasted unit salesDesired ending inventoryBeginning inventoryUnits to be producedUnits producedMaterial costLabour costOverhead costInterestEmployee bonusesJanuaryTotal cash paymentsFebruaryDecemberJanuaryLAb. Prepare a monthly summary of cash payments for January through June. Ace produced 900 units in December.Ace Battery CompanySummary of Cash paymentsFebruaryMarch$MarchLAApril11LAMay[TOJuneAprilBAMayJulyJune][

The formula used to determine the units produced is as follows:Units to be produced = Expected Sales…

January 1,100 May February 950 June March April 900 July 1,400 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December January's beginning inventory) is 1,430 units, which is consistent with this policy. 1,650 1,800 1,500 Materials cost $12 per unit and are paid for in the month after production. Labour cost is $5 per unit and is paid in the month the cost is ncurred. Overhead costs are $7,500 per month. Interest of $8,300 is scheduled to be paid in March, and employee bonuses of $13,500 will be paid in June. . Prepare a monthly production schedule for January through June. (Enter all values as positive value.) Ace Battery Company Production Schedule Forecasted unit sales Desired ending inventory Beginning inventory Units to be produced Units produced Material cost Labour cost Overhead cost Interest Employee bonuses Total cash payments January December February January $ . Prepare a monthly summary of cash payments for January through June. Ace produced 900 units in December. Ace Battery Company Summary of Cash payments February March $ March $ April May $ April June $ $ May July $ June

January 1,100 May February 950 June March April 900 July 1,400 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December January's beginning inventory) is 1,430 units, which is consistent with this policy. 1,650 1,800 1,500 Materials cost $12 per unit and are paid for in the month after production. Labour cost is $5 per unit and is paid in the month the cost is ncurred. Overhead costs are $7,500 per month. Interest of $8,300 is scheduled to be paid in March, and employee bonuses of $13,500 will be paid in June. . Prepare a monthly production schedule for January through June. (Enter all values as positive value.) Ace Battery Company Production Schedule Forecasted unit sales Desired ending inventory Beginning inventory Units to be produced Units produced Material cost Labour cost Overhead cost Interest Employee bonuses Total cash payments January December February January $ . Prepare a monthly summary of cash payments for January through June. Ace produced 900 units in December. Ace Battery Company Summary of Cash payments February March $ March $ April May $ April June $ $ May July $ June

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

Cousin Eddy provides you with his sales forecast for the next four months: April May 750 June July 790 Sales (Units) 670 The company wants to end each month with ending finished goods Inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 268 units. Assume July's budgeted production is 700 units. In addition, each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month's production needs. Beginning raw materials inventory for April was 842 pounds. Assume direct materials cost $5 per pound. Required: For May, how many units must be produced? (Hint: This is your production budget) Submit your answer below 700 with all work submitted via email.
On January 1 the company had 330 widgets in finished good inventory. The company policy is to maintain an inventory of 15% of next montha sales. The company forecast the following sales: Jan. 2,200 Feb. 2,800 March 3,500 April 4,000 Determine the required production for January?
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
1) Gertrude Products expects the following sales of its single product: Units July 6,000 August 6,500 September 7,200 October 7,800 November 8,800 Gertrude desires an ending finished goods inventory to be equal to 20% of the next month's sales needs. July 1 inventory is projected to be 1,000 units. Each unit requires 5 pounds of Chemical A and 14 pounds of Chemical B. July 1 materials inventory includes 10,600 pounds of Chemical A and 76,000 pounds of Chemical B. Gertrude desires to maintain a Chemical A inventory equal to 30% of next month's production needs and a Chemical B inventory equal to 100% of next month's production needs. a Prepare a production budget for Gertrude for July, August and September. a. Production July August September Qtr. Total Sales +Ending Inv. -Beginning Inv. Production b. Prepare a direct materials…
Wesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $40. Wesley expects the following unit sales: January 2,200 February 2,500 March 2,700 April 2,500 May 2,100 Wesley’s ending finished goods inventory policy is 35 percent of the next month’s sales. Suppose each handisaw takes approximately 0.65 hour to manufacture, and Wesley pays an average labor wage of $13.50 per hour. Each handisaw requires two plastic components that Wesley purchases from a supplier at a cost of $3.00 each. The company has an ending direct materials inventory policy of 10 percent of the following month’s production requirements. Materials other than the plastic components total $4.50 per handisaw. Manufacturing overhead for this product includes $66,000 annual fixed overhead (based on production of 24,000 units) and $0.90 per unit variable manufacturing overhead. Wesley’s selling expenses are 6 percent of…
INFORMATION: Brait Limited produces a single product and forecasted the following for the first three months of the year: January March February 2 400 Sales (units) 2 200 2 600 The company's policy is to maintain closing inventory at a level of 50% of the following months forecasted sales. Material and labour requirements are as follows: Material 2 kg per unit @ R60 per kg Labour 3 hours per unit Material inventory levels were as follows: December 1 100 Closing inventory (kg) January 1 250 REQUIRED: The total material purchase cost for January is: A. R276 000 B. R408 000 C... 8285 000 February 1 400 March 1 300
please answer all parts within 30 minutes.....
None
Lens Junction sells lenses for $43 each and is estimating sales of 15,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $14 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,300 4,900 4,900 Direct materials: silicon 8,400 9,100 9,300 Direct materials: solution 11,000 11,800 12,900
Lens Junction sells lenses for $44 each and is estimating sales of 16,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $22 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,500 5,100 5,200 Direct materials: silicon 8,600 9,000 9,300 Direct materials: solution 11,400 12,200 12,800 c). Prepare direct materials budget for silicon. d). Prepare a direct labor budget.
2. Muddy Waters Industries has projected sales of its product for the next 6 months: 300 units January February 700 units March 1,000 units April Мay 1,000 units 400 units June 300 units Each unit is sold at $40 per unit. The cost of goods sold is typically 40% of the month's budgeted sales revenue. Muddy Waters tries to maintain a Finished Goods ending inventory equal to the 60% of next month's cost of goods sold. January beginning inventories are expected to conform to company policy. Prepare a purchase budget for March, and April
PROVIDE Answer with calculation