production needs
January | February | March | ||
budgeted production | 60000 | 75000 | 100000 | |
Raw material per unit | 2kg | 2kgs | 2kgs | |
Total Raw material required | 120000 | 150000 | 200000 | |
Add: Raw material required at the end | [2X*30%] | 60000[200000*30%] | ||
Less: Beginning inventory | 36000 | 45000 | ||
Purchase | 129000 | 165000 | 188000 | |
120000+(2X*30%)-36000 = 129000
2X*30% - 36000=129000-120000
2X*30% =9000+36000
0.6X = 45000
X=75000
production is 75000 in February
2. flexible budget flexes according to actual machine hours however fixed cost remains constant
Variable costs | 6240 | [7800/15000 * 12000] |
fixed cost | 18000 | remains constant irrespective of machine hours |
Total flexible cost | D ANSWER | |
3.cash collection of December
December | ||
cash sale of december | 30000 | [120000*25%] |
October receipts | 18000 | [160000*75%*15%] |
November receipts | 40500 | [180000*75%*30%] |
December receipts | 45000 | [120000*75%*50%] |
Total cash collection in December | 133500 |
4.
april | may | june | ||
sales | 100000 | 120000 | 160000 | |
Add: desired ending inventory | 24000[120000*20%] | [X*20%] | ||
Less: beginning invetory | 20000 | 24000 | ||
production | 104000 | 128000 |
120000 + .20X-24000 = 128000
X = 160000 units
5.FALSE
budget are used for both planning and control of operations.
Budget is a forecast of future events which helps in planning future as well as control the costs and revenues.
Marple Company's budgeted production in units and budgeted raw materials purchases over the next three months...
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: 17 Budgeted production (in units) Budgeted raw materials purchases (in pounds) January February March 70,200 ? 81,000 221,160 154,600 159,800 Four pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have...
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) 54,000 ? 80,000 Budgeted raw materials purchases (in pounds) 115,800 141,800 197,800 Two pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have 31,000...
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: February Budgeted production (In units) Budgeted raw materials purchases (In pounds) January 122,000 282,400 March 80,000 364,400 308,400 Two pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have 21,000 pounds...
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) 71,300 ? 86,500 Budgeted raw materials purchases (in pounds) 199,977 171,100 165,300 Three pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 21% of the following month's production needs. The company is expected to have 44,919...
Q1 Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) 70,200 ? 81,000 Budgeted raw materials purchases (in pounds) 221,160 154,600 159,800 Four pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have...
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) 78,000 ? 80,000 Budgeted raw materials purchases (in pounds) 174,600 200,600 256,600 Two pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have 28,000...
Paul Corp's budgeted production in units and budgeted raw material purchases over the next three months are given below: February Budgeted production (units) Budgeted raw material purchases (in lbs) January 50,000 106,000 March 80,000 188,000 132,000 Materials required to produce one unit of product: The % of materials prepared in the beginning inventory equals to Materials on Jan. 1 2 lbs 30% of that month's production needs 30,000 pounds Budgeted production for February should be: A. 54,000 units 60,000 units...
Budgeted sales in Washburn Company over the next four months are given below: September October November December Budgeted sales $100,000 $160,000 $180,000 $120,000 Twenty-five percent of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The...
Provide formulas and procedure in excel QUESTION 9 Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) 70,200 ???? 81,000 Budgeted raw materials (in pounds) 143,400 154,600 159,800 Four pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 31% of the following month's production needs....
Shorstein Manufacturing Company purchases raw materials on account each month. Purchases are paid for according to the following schedule: 30% is paid in the month of the purchase 60% is paid in the month following the purchase 10% is paid in the second month following the purchase Budgeted purchases are as follows: March $75,000 April $90,000 May $85,000 How much will be reported for Accounts Payable for material purchases as of the end of May? $59,500 O $68,500 $87,000 $95,500...