EYK9-1. Business Decision Case The sales department of Donovan Manufacturing, In
ID: 2559027 • Letter: E
Question
EYK9-1. Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the
following sales forecast for the months of January through March 2016 for its only two products:
50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired
unit inventories at March 31, 2016, are 10% of the next quarter’s unit sales forecast, which are
60,000 units of J and 30,000 units of K. The January 1, 2016, unit inventories were 5,000 units of
J and 2,000 units of K.
Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture; K
requires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchase
cost of B is $5 per pound. Materials A and B on hand at January 1, 2016, were 19,000 pounds of A
and 7,000 pounds of B. Desired inventories at March 31, 2016, are 14,000 pounds of A and 8,000
pounds of B.
Each unit of J requires 0.5 hour of direct labor in the factory; each unit of K requires 1.0 hour
of direct labor. The average hourly rate for direct labor is $12 per hour. Estimated manufacturing
overhead cost is $6 per direct labor hour plus $90,000 per month. Selling and administrative expenses
are estimated to be 10% of sales revenue plus $180,000 per month.
Cash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30%
of the credit sales for the quarter ended March 31, 2016, will occur in January, 30% in February,
and 40% in March. Of credit sales (December through March), 40% will be collected as cash in the
month of sale and 55% will be collected in the following month. The remainder will be uncollectible.
Cash collected in January 2016 from December 2015 sales will be $1,050,000.
The January 1, 2016, cash balance was $70,000. The minimum acceptable cash balance at
the end of each month is $60,000. Short-term borrowings (6-month term) are made in multiples of
$10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interest
payment is made the month following the borrowing. Cash disbursements (excluding interest on
short-term borrowings) are estimated as follows:
January February March
Manufacturing costs....................$1,500,000 $1,300,000 $1,400,000
Selling and administrative expenses .......390,000 410,000 400,000
Interest expense.......................90,000 90,000 90,000
Income tax payment....................0 0 210,000
Capital expenditures ...................124,000 110,000 50,000
Cash dividends........................300,000 0 0
Required
a. Prepare the sales budget for the quarter ended March 31, 2016.
b. Prepare the production budget for the quarter ended March 31, 2016.
c. Prepare the direct material budget for the quarter ended March 31, 2016.
d. Prepare the direct labor budget for the quarter ended March 31, 2016.
e. Prepare the manufacturing overhead budget for the quarter ended March 31, 2016.
f . Prepare the selling and administrative expense budget for the quarter ended March 31, 2016.
g. Prepare a schedule of cash collected from customers for the quarter ended March 31, 2016.
h. Prepare the cash budget for the quarter ended March 31, 2016
EYK9-1. Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the L04 following sales forecast for the months of January through March 2016 for its only two products 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 2016, are 10% of the next quarter's unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January 1, 2016, unit inventories were 5,000 units of J and 2,000 units of K Each unit of J requires 3 pounds of materialA and 2 pounds of material B for its manufacture; K requires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchase cost of B is $5 per pound. Materials A and B on hand at January 1, 2016, were 19,000 pounds of A and 7,000 pounds of B. Desired inventories at March 31, 2016, are 14,000 pounds of A and 8,000 pounds of B. Eac h unit of J requires 0.5 hour of direct labor in the factory; each unit of K requires 1.0 hour of direct labor. The average hourly rate for direct labor is $12 per hour. Estimated manufacturing Chaptor 9 Planning and Budgeting overhead cost is $6 per directlabor hour plus $90,000 per month. Selling and administrative expenses are estimated to be 10% of sales revenue plus $180,000 per month. Cash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30% of the credit sales for the quarter ended March 31, 2016, will occur in January, 30% in February and 40% in March. Of credit sales (December through March), 40% will be collected as cash in the month of sale and 55% will be collected in the following month. The remainder will be uncollectible Cash collected in January 2016 from December 2015 sales will be $1,050,000. The January 1, 2016, cash balance was $70,000. The minimum acceptable cash balance at the end of each month is $60,000. Short-term borrowings (6-month term) are made in multiples of $10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interest payment is made the month following the borrowing. Cash disbursements (excluding interest on short-term borrowings) are estimated as follows: January February March $1,500,000 $1,300,000 $1,400,000 400,000 90,000 210,000 costs Selling and administrative expenses Interest expense Income tax payment. 390,000 90,000 410,000 90,000 Capital expenditures 124,000 110,000 50,000 Cash dividends 300,000 Required a. Prepare the sales bu b. Prepare the production budget for the quarter ended March 31, 2016 c. Prepare the direct material budget for the quarter ended March 31, 2016 d. Prepare the direct labor bu e. Prepare the manufacturing overhead budget for the quarter ended March 31, 2016. f. Prepare the selling and administrative expense budget for the quarter ended March 31, 2016. g. Prepare a schedule of cash collected from customers for the quarter ended March 31, 2016 h. Prepare the cash budget for the quarter ended March 31, 2016. dget for the quarter ended March 31, 2016. dget for the quarter ended March 31, 2016.Explanation / Answer
Solution:
Part a --- Sales Budget
Sales Budget for the quarter ended March 31, 2016
Product J
Product K
Total
Budgeted Sales (in units)
50,000
30,000
Selling price per unit
$90.00
$70.00
Sales Revenue
$4,500,000
$2,100,000
$6,600,000
Part b --- Production Budget
Production Budget
For the quarter ended March 31, 2016
Product J
Product K
Budgeted Sales (in units)
50,000
30,000
Plus: Desired Ending Inventory Dec 31
6000
3000
Total Units needed
56000
33000
Less: Expected Beginning Inventory Jan 1
5000
2000
Production Requirements
51000
31000
Part c –
Direct Materials Budget
For the quarter ended March 31, 2016
Material A
Material B
GROSS TOTAL
Product J
Product K
Total
Product J
Product K
Total
Production requirements (from part 2)
51000
31000
51000
31000
Raw material required per unit (pounds)
3.00
2.00
2.00
4.00
Raw material required for production (pounds)
153000
62000
215000
102000
124000
226000
Plus: Desired Ending Inventory Raw material
14000
8000
Total raw materials need
229000
234000
Less: Beginning direct materials pound
19000
7000
Raw material to be purchased
210000
227000
Price (per pound)
$9.00
$5
Cost of purchases (paperboard)
$1,890,000
$1,135,000
$3,025,000
Part d --- Direct Labor Budget
Direct labor Cost budget
For the quarter ended March 31, 2016
Product J
Product K
Total
Units to be produced (from part 2)
51000
31000
Required Direct Labor time per unit
0.50
1.00
Total required direct labor time
25500
31000
Direct labor rate per hour
$12
$12
Total Direct labor cost
$306,000
$372,000
$678,000
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you
Pls ask separate question for remaining parts.
Sales Budget for the quarter ended March 31, 2016
Product J
Product K
Total
Budgeted Sales (in units)
50,000
30,000
Selling price per unit
$90.00
$70.00
Sales Revenue
$4,500,000
$2,100,000
$6,600,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.