Question

Exercise 5-14 Mackenzie Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on

0 0
Add a comment Improve this question Transcribed image text
Answer #1

purchase budget for product AM972 (Raw Material)-

For AM972
Ist quarter 2nd Quarter 3rd Quarter 4th Quarter 1st quarter next year Annual
production requirement (in gallons) 5520 8300 9780 13260 7000 36860
A Raw material required for production AM972 150 (in ounces) 828000 1245000 1467000 1989000 1050000 5529000
B add Desired closing inventory (0.20*next quarter production needs) 249000 293400 397800 210000 1150200
Total Requirements (A+B) 1077000 1538400 1864800 2199000 6679200
less Beginning inventory (ist quarter given & closing of last quarter) 80000 249000 293400 397800 1020200
purchase requirement 997000 1289400 1571400 1801200 5659000
purchase requirement in $ 149550 193410 235710 270180 848850

Purchase budget for CA38 -

For AM972
Ist quarter 2nd Quarter 3rd Quarter 4th Quarter 1st quarter next year Annual
production requirement (in gallons) 5520 8300 9780 13260 7000 36860
A Raw material required for production AM972 25 (in ounces) 138000 207500 244500 331500 175000 921500
B add Desired closing inventory (0.20*next quarter production needs) 41500 48900 66300 35000 191700
Total Requirements (A+B) 179500 256400 310800 366500 1113200
less Beginning inventory (ist quarter given & closing of last quarter) 30000 41500 48900 66300 186700
purchase requirement 149500 214900 261900 300200 926500
purchase requirement in $ 35880 51576 62856 72048 222360

Consolidate purchase budget

Total (AM972 & CA38)
Ist quarter 2nd Quarter 3rd Quarter 4th Quarter 1st quarter next year Annual
production requirement (in gallons) 5520 8300 9780 13260 7000 36860
A Raw material required for production AM972 25 (in ounces) 966000 1452500 1711500 2320500 1225000 6450500
B add Desired closing inventory (0.20*next quarter production needs) 290500 342300 464100 245000 1341900
Total Requirements (A+B) 1256500 1794800 2175600 2565500 7792400
less Beginning inventory (ist quarter given & closing of last quarter) 110000 290500 342300 464100 1206900
purchase requirement 1146500 1504300 1833300 2101400 6585500
purchase requirement in $ 185430 244986 298566 342228 1071210

Please check with your answer and let me know.

Add a comment
Know the answer?
Add Answer to:
Exercise 5-14 Mackenzie Chemicals has developed a new window cleaner that requires two ingredients, AM972 and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • CALCULATOR PRINTER VERSION BACK NEXT SOURCES Exercise 5-14 Marigold Chemicals has developed a new window cleaner...

    CALCULATOR PRINTER VERSION BACK NEXT SOURCES Exercise 5-14 Marigold Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Marigold has developed the following budgeted production for the coming year. 1st Quarter 5,030 2nd Quarter 7,910 3rd Quarter 9.000 4th Quarter 13,260 Ist Quarter Next Year 6,070 Forecasted production (gallons) Each gallon of window cleaner requires 145 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Marigold 50.15....

  • Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and 512L5. The S12L7 sells...

    Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and 512L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 2011 960 1,560 2,640 1,680 6,720 Second quarter, 2011 Third quarter, 2011 Fourth quarter, 2011 First quarter, 2012 6,360 5,520 4,680 1,080 1,440 The vice president of sales believes that the projected sales are realistic and can be achieved...

  • Production Budget Assume that stillwater Designs produces two automotive subwoofers: S12L7 and 512L5. The 512L7 sells...

    Production Budget Assume that stillwater Designs produces two automotive subwoofers: S12L7 and 512L5. The 512L7 sells for $475, and the 512L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter 2011 960 Second quarter, 2011 Third quarter, 20Y1 Fourth quarter, 2011 2,640 6,720 5,520 1,080 1,560 1,680 6,360 4,680 1.440 First quarter, 2012 The vice president of sales believes that the projected sales are realistic and can be achieved...

  • Exercise 7-4 Preparing Direct Materials and Direct Labour Budgets (LO2 - CC7, 8) The production department...

    Exercise 7-4 Preparing Direct Materials and Direct Labour Budgets (LO2 - CC7, 8) The production department of Hareston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 2nd ist Quarter Quarter 8,800 9,800 3rd Quarter 7,800 4th Quarter 6,800 Units to be produced In addition, the beginning raw materials inventory for the first quarter is budgeted to be 2,300 kilograms and the beginning accounts payable for the first quarter are budgeted...

  • Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3] The marketing department of Jessi Corporation has subm...

    Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,688 1 3, 15.500 14.5ee The selling price of the company's product is $25 per unit Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5%...

  • Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5) The production department of Zan Corporation...

    Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5) The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year 1st Quarter 13,000 2nd Quarter 16,Bee 3rd Quarter 15, eee 15, eee 4th Quarter 14,689 Units to be produced In addition, 19,500 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 12.200 2nd Quarter 13,200 3rd Quarter 15.200 4th Quarter 14,200 Budgeted unit sales The selling price sales are expected to be uncollectible. The beginning balance of accounts receivable, all The company expects to start the first quarter with 2,440 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced e produced 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7,000 10,000 9,000 8,000 In addition, 8,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,200. Each unit requires 5 grams of raw material that costs...

  • The marketing department of fiscal year (all sales are on account) Jessi Corporation has submitted the...

    The marketing department of fiscal year (all sales are on account) Jessi Corporation has submitted the following sales forecast for the upcoming 1st Quarter 11,200 2nd Quarter 12,200 3rd Quarter 14,200 4th Quarter 13,200 Budgeted unit sales The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • Question 1 Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the company's owner, has developed...

    Question 1 Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the company's owner, has developed the following sales forecast for 2018. 1st Quarter 2,541 2nd Quarter 2,778 3rd Quarter 2,927 4th Quarter 2,276 Forecasted sales (tables) Because of the time needed to create each table, Swifty maintains an ending Finished Goods Inventory of 20% of the following quarter's budgeted sales. Swifty has been following this inventory policy for several years. The company ended 2017 with 508 tables on hand....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT