Budget

profileHiram922

Accounting 2

Fill in the missing information 

  • 2 years ago
  • 10
files (5)

PA7.docx

Fill in the missing information from the following schedules:

Sales Budget, For the Year Ending December 31, 2018, Quarter 1, Quarter 2, Quarter 3, Quarter 4, Total (respectively): Expected sales (units) 7,500, 8,250, 8,750, 9.000, ?; Sales price per unit $45, 50, 50, 55; Total sales revenue $337,500, 412,500, 437,500, ?, ? Production Budget For the Year Ending December 31, 2018, Quarter 1, Quarter 2, Quarter 3, Quarter 4, Q 1Year 2 (respectively): Expected Sales 7,500, 8,250, 8,750, 9,000, 8,000; plus Desired ending inventory 1,650, 1,750, 1,800, ?, 900; Total required units 9,150, 10,000, 10,550, 10,600, 8,900; minus Beginning Inventory 1,500, 1,650, 1,750, 1,800, 1,600; Equals required production 7,650, 8,350, 8800, ?, 7,300; Total ? Direct Materials Budget, For the Year Ending December 31, 2018, Quarter 1, Quarter 2, Quarter 3, Quarter 4, Total (respectively): Units to be produced 7,650, 8,350, 8,800, 8,800, 33,600; Times Direct material per unit 2, 2, 2, 2, 2; Total pounds needed for production 15,300, 16,700, 17,600, 17,600, 67,200; Add: desired ending inventory 4,175, 4,400, 4,400, 3,650, 3,650; Total material required 19,475, 21,100, 22,000, 21,250, 70,850; Less: beginning inventory 0, 4,175, 4,400, 4,400, –; Pounds of direct material purchase requirements 19,475, 16,925, 17,600, 16,850, 70,850; Cost per pound $1.50, 1.50, 1.50, 1.50, 1.50; Total cost of direct material purchase $29,213, 25,388, 26,400, 25,275, 106,275; Total ? $106,275. Direct Labor Budget, For the Year Ending December 31, 2018, Quarter 1, Quarter 2, Quarter 3, Quarter 4, Total (respectively): Units to be produced 7,650, 8,350, 8,800, 8,800, 33,600; Direct labor hours per unit 0.75, 0.75, 0.75, 0.75, 0.75; Total required direct labor hours 5,738, 6,263, 6,600, 6,600, 25,200; Labor cost per hour $25, 25, 25, 25, 25; Total direct labor cost $143,438, 156,563, 165,000, 165,000, 630,000.

image1.jpeg

image2.jpeg

image3.jpeg

image4.jpeg