Micro Products, Inc., has developed a very powerful electronic calculator. Each calculator requires four small "chips" that cost $2 each and are purchased from an overseas supplier. Micro Products has prepared a production budget for the calculator by quarters for Year 2 and for the first quarter of Year 3, as shown below:
Year 2 Year 3
First Second Third Fourth First
Budgeted production, in calculators 60,000 85,000 144,000 94,000 70,000
The chip used in production of the calculator is sometimes hard to get, so it is necessary to carry large inventories as a precaution against stock outs. For this reason, the inventory of chips at the end of a quarter must be equal to 20% of the following quarter's production needs. Some 48,000 chips will be on hand to start the first quarter of Year 2.
Prepare a direct materials budget for chips, by quarter and in total, for Year 2. At the bottom of your budget, show the dollar amount of purchases for each and for the year in total.
First Second Third Fourth Year
Production needs - chips
Add: Desired ending inventory-chips
Total needs - chips
Less: Beginning inventory-chips
Required purchases - chips
Cost of purchases
The solution explains how to prepare a direct material purchases budget
Calculating a Production, Direct Materials and Static Budget when given projected sales and inventory levels.
3. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4.
Management desires to have an ending finish goods inventory equal to 25% of th enext quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2014.
4. Perine Company has 2,000 pounds of raw materials in its December 31, 2013, ending inventory. Required production for January and February of 2014 are 4,000 and 5,000 units, respectively. Two pounds of raw materials are needed for each unit, and the estimated cost per pound is $6. Management desires an ending inventory equal to 25% of next month's materials requirements. Prepare the direct materials budget for January.
6. For the quarter ended March 31, 2014, Maris Company accumulates the following sales data for its product, Garden-Tools: $310,000 budget; $305,000 actual.
In the second quarter, budgeted sales were $380,000, and actual sales were $384,000. Prepare a static budget report for the second quarter and for the year to date.View Full Posting Details