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.
Exercise 5-14 Mackenzie Chemicals has developed a new window cleaner that requires two ingredients, AM972 and...
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 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 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 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 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 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 (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 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 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 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....