CASH COLLECTION BUDGET | |||||||||||
January | February | March | Total for the Quarter | April | May | ||||||
A | Sales Revenue | $99,600 | $118,100 | $115,200 | $332,900 | $108,000 | $103,200 | ||||
B=A*35% | Cash Sales | $34,860 | $41,335 | $40,320 | $116,515 | $37,800 | $36,120 | ||||
C=A*65% | Credit sales | $64,740 | $76,765 | $74,880 | $216,385 | $70,200 | $67,080 | ||||
D | Collection for Credit sales | $48,000 | $64,740 | $76,765 | $189,505 | ||||||
E=B+D | TotalCash Collection | $82,860 | $106,075 | $117,085 | $306,020 | ||||||
Collection for Credit sales during January=Balance in Accounts receivable as on End December of previous year | |||||||||||
PRODUCTION BUDGET | |||||||||||
January | February | March | Total for the Quarter | April | May | ||||||
A | Sales Revenue | $99,600 | $118,100 | $115,200 | $332,900 | $108,000 | $103,200 | ||||
B | Sales Price Per unit | $12 | $12 | $12 | $12 | $12 | $12 | ||||
C=A/B | Unit sales | 8300 | 9842 | 9600 | 27742 | 9000 | 8600 | ||||
D | Ending Inventory (units) | 984 | 960 | 900 | 860 | ||||||
E=C*10% | Beginning inventory (units) | 830 | 984 | 960 | 900 | ||||||
F=C+D-E | Budgeted production (Units) | 8454 | 9818 | 9540 | 27812 | 8960 | |||||
DIRECT MATERIALS BUDGET | |||||||||||
January | February | March | Total for the Quarter | April | May | ||||||
A | Budgeted production (Units) | 8454 | 9818 | 9540 | 27812 | 8960 | |||||
B | Direct material Required per unitof production (in Pounds) | 3 | 3 | 3 | 3 | 3 | |||||
C=A*B | Total Direct materials Needed(Pounds) | 25362 | 29454 | 28620 | 83436 | 26880 | |||||
D | Ending Inventory | 5891 | 5724 | 5376 | |||||||
E=C*20% | Beginning Inventory | 5072 | 5891 | 5724 | |||||||
F=C+D-E | Budgeted Purchase (Pounds) | 26180 | 29287 | 28272 | 83740 | ||||||
CASH PAYMENT BUDGET FOR DIRECT MATERIAL PURCHASE | |||||||||||
January | February | March | Total for the Quarter | ||||||||
A | Budgeted Purchase (Pounds) | 26180 | 29287 | 28272 | 83740 | ||||||
B | Cost of material per pound | $2 | $2 | $2 | $2 | ||||||
C=A*B | Total Purchase in dollars | $52,361 | $58,574 | $56,544 | $167,479 | ||||||
D=C*20% | Payment for the month'sPurchase | $10,472 | $11,715 | $11,309 | $33,496 | ||||||
E | Payment for earlier Purchase | $43,000 | $41,889 | $46,860 | $131,748 | ||||||
F=D+E | Budgeted Cash Payment | $53,472 | $53,604 | $58,168 | $165,244 | ||||||
Payment for Earlier Purchase during January=Balance in Accounts Payable as on End December of previous year | |||||||||||
Homework: 9-57A Score: 0 of 5 pts P9-57A (similar to) Click the icon to view the...
Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Wrap Text Auto Fil- General Paste BIU - A Merge & Center E Conditional Format as Cell Formatting Insert Delete Formar Clear- Table Styles Clipboard Font Alignment Number Styles Cells K11 A D F G H J 1 Comprehensive Budgeting Problem 20 points Silverman Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...
The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing its master budget for the first que budgeting problem (Learning Objectives 2 & 3) ing year. The following data pertanto s preparing its master budget for the first quarter of the upcom- u facturing's operations Current Assets as of December 31 (prior year): Cash.. $ 4,600 Accounts receivable, net $ 46,000 Inventory $ 15,600 Property, plant, and equipment, net $121,000 Accounts payable. $ 43,000...
PLEASE PLEASE I NEED ANSWER FOR BALANCE SHEET AS OF MARCH 31 Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and equipment, net $121,500.00; Accounts payable $42,800.00; Capital stock $124,500.00; Retained earnings $22,800.00 A: Actual Sales in December were$72,000. Selling price per unit projected to remain stable at $12 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follow: January $ 104,400 , February $...
PLEASE PLEASE I NEED ANSWER FOR BALANCE SHEET AS OF MARCH 31 Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and equipment, net $121,500.00; Accounts payable $42,800.00; Capital stock $124,500.00; Retained earnings $22,800.00 A: Actual Sales in December were$72,000. Selling price per unit projected to remain stable at $12 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follow: January $ 104,400 , February $...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Needing help with this! I have been working on this question for
over 2 hours! If anyone could please help me out as it is due
tomorrow morning at 8am! if you do ill be forever in debt!.
Homework: Chapter 9 Homework Score: 0.12 of 1 pt & P9-57A (similar to) Save 2 of 4 (3 complete) HW Score: 39.12%, 1.56 of 4 pts Question Help Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming...
Please pleeease help me. I have been struggling for 3 days to find the answer. I NEED ANSWER FOR Budgeted Manufacturing Cost per Unit account and Budgeted Income statement and balance sheet. Please show calculations if possible. Thank you Current assets as of December 31 (prior year): Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and equipment, net $121,500.00; Accounts payable $42,800.00; Capital stock $124,500.00; Retained earnings $22,800.00 A: Actual Sales in December were$72,000. Selling price...
PLEASE, PLEASE. HELP ME I NEED ANSWER FOR Combined Cash Budget account and Budgeted Manufacturing Cost per Unit account. Please show calculations if possible. Thank you Current assets as of December 31 (prior year): Cash $4,650.00, Accounts receivable, net $57,600.00, Inventory $15,600.00; Property, plant, and equipment, net $121,500.00; Accounts payable $42,800.00; Capital stock $124,500.00; Retained earnings $22,800.00 A: Actual Sales in December were$72,000. Selling price per unit projected to remain stable at $12 per unit throughout the budget period. Sales...
3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget. (Hint: Unit sales - Sales in dollars / Selling price per unit.) Prepare a direct materials budget. 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 7. Prepare a cash payments...