70.2K

Verified Solution

Link Copied!

Would anyone happen to know the formulas to this excel sheet?

John Company, a manufacturer, predicts sales of 9.750 units in January, 9.000 units in February, 12,750 units in March, and 14,000 units in Apri. The company wants each month's ending finished goods inventory to equal 30% of neit month's predicted unit sales. Beginning finished goods inventery for danuary is 2.925 units. Each unit of finiahed goocs requires 0.35 pounds of direct materials at a cost of $11.00 per pound, and 4.5 hours of direct labor at a cost of $18 per hour. Addilionally, the company wants each month's ending raw materiais inventory to equal 50\% of neat month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget. John Company, a manufacturer, predicts sales of 9.750 units in January, 9.000 units in February, 12,750 units in March, and 14,000 units in Apri. The company wants each month's ending finished goods inventory to equal 30% of neit month's predicted unit sales. Beginning finished goods inventery for danuary is 2.925 units. Each unit of finiahed goocs requires 0.35 pounds of direct materials at a cost of $11.00 per pound, and 4.5 hours of direct labor at a cost of $18 per hour. Addilionally, the company wants each month's ending raw materiais inventory to equal 50\% of neat month's budgeted production. Prepare a sales budget, a production budget, a direct materials and a direct labor budget

Answer & Explanation Solved by verified expert

See Answer