The production department of Zan Corporation has submitted the following forecast of units to be produced...
Free
60.1K
Verified Solution
Question
Accounting
The production department of Zan Corporation has submitted thefollowing forecast of units to be produced by quarter for theupcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4thQuarter Units to be produced 10,000 13,000 12,000 11,000 Inaddition, 20,000 grams of raw materials inventory is on hand at thestart of the 1st Quarter and the beginning accounts payable for the1st Quarter is $5,800. Each unit requires 8 grams of raw materialthat costs $1.40 per gram. Management desires to end each quarterwith an inventory of raw materials equal to 25% of the followingquarter’s production needs. The desired ending inventory for the4th Quarter is 7,000 grams. Management plans to pay for 60% of rawmaterial purchases in the quarter acquired and 40% in the followingquarter. Each unit requires 0.40 direct labor-hours and directlaborers are paid $11.50 per hour. Required: 1.&2. Calculatethe estimated grams of raw material that need to be purchased andthe cost of raw material purchases for each quarter and for theyear as a whole. 3. Calculate the expected cash disbursements forpurchases of materials for each quarter and for the year as awhole. 4. Calculate the estimated direct labor cost for eachquarter and for the year as a whole. Assume that the direct laborworkforce is adjusted each quarter to match the number of hoursrequired to produce the estimated number of units produced.
The production department of Zan Corporation has submitted thefollowing forecast of units to be produced by quarter for theupcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4thQuarter Units to be produced 10,000 13,000 12,000 11,000 Inaddition, 20,000 grams of raw materials inventory is on hand at thestart of the 1st Quarter and the beginning accounts payable for the1st Quarter is $5,800. Each unit requires 8 grams of raw materialthat costs $1.40 per gram. Management desires to end each quarterwith an inventory of raw materials equal to 25% of the followingquarter’s production needs. The desired ending inventory for the4th Quarter is 7,000 grams. Management plans to pay for 60% of rawmaterial purchases in the quarter acquired and 40% in the followingquarter. Each unit requires 0.40 direct labor-hours and directlaborers are paid $11.50 per hour. Required: 1.&2. Calculatethe estimated grams of raw material that need to be purchased andthe cost of raw material purchases for each quarter and for theyear as a whole. 3. Calculate the expected cash disbursements forpurchases of materials for each quarter and for the year as awhole. 4. Calculate the estimated direct labor cost for eachquarter and for the year as a whole. Assume that the direct laborworkforce is adjusted each quarter to match the number of hoursrequired to produce the estimated number of units produced.
Answer & Explanation Solved by verified expert
Rawmaterial Budget and Cash Disbursement | |||||
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
Units to be produced | 10000 | 13000 | 12000 | 11000 | 46000 |
grams/unit | 8 | 8 | 8 | 8 | |
Rawmaterial Quantity Required 8gm | 80000 | 104000 | 96000 | 88000 | 368000 |
Ending Inventory Rawmaterial 25% of next quarter production needs | 26000 | 24000 | 22000 | 7000 | |
Total Rawmaterial Required | 106000 | 128000 | 118000 | 95000 | 447000 |
Less Beginning Inventory | 20000 | 26000 | 24000 | 22000 | |
Rawmaterial Inventory needed (grams) | 86000 | 102000 | 94000 | 73000 | 355000 |
Raw material Cost/gram | $ 1.4 | $ 1.4 | $ 1.4 | $ 1.4 | |
Total Rawmaterial Cost Purchase | $ 120,400 | $ 142,800 | $ 131,600 | $ 102,200 | 497000 |
Expected Cash Disbursement | |||||
60% in same quarter | $ 72,240 | $ 85,680 | $ 78,960 | $ 61,320 | 298200 |
40% in following quarter | $ 5,800 | $ 48,160 | $ 57,120 | $ 52,640 | 163720 |
Total Cash Disbursement | $ 78,040 | $ 133,840 | $ 136,080 | $ 113,960 | 461920 |
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total | |
Units to be produced | 10000 | 13000 | 12000 | 11000 | 46000 |
Direct Labour/Unit | 0.4 | 0.4 | 0.4 | 0.4 | |
Total Direct Labour Hours | 4000 | 5200 | 4800 | 4400 | |
Direct Labour cost/hour | $ 11.5 | $ 11.5 | $ 11.5 | $ 11.5 | |
Direct Labour Cost | $ 46,000 | $ 59,800 | $ 55,200 | $ 50,600 | $ 211,600 |
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.