Question
1. The following information pertains to the XYZ Manufacturing Company for the months April through July of 2012. Planned sales in units for April, May,
1.The following information pertains to the XYZ Manufacturing Company for the months April through July of 2012.
Planned sales in units for April, May, June, and July are 1,200, 1,500, 1,650, and 1,750 units respectively.
Unit sales price for April, May, June, and July is respectively Birr 120, 135, 140, and 130.
Desired ending inventory is 10 percent of the next month`s sales.
Beginning inventory is the same as the previous month`s ending inventory.
Ending inventory of March 31,2012 is 160 units
Material needs per unit are 6 pounds in each month.
Desired ending inventory of materials is 10 percent of the next month's units needed for production.
Beginning inventory of materials is the same as the prior month`s ending inventory.
Ending inventory of materials of March 31, 2012 is 400 units
Unit price of materials is Birr 25 in each month.
Direct labor hours per unit are 8 in each month.
Direct labor cost per hour is Birr 30 in each month.
Required:
Based on the above information, PREPARE the following budgets for the quarter ending June 30, 2012:
a)Sales budget
b)Production Budget
c)Direct material budget
d)Direct labor budget
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started