ch10sweeneySTUDENT

.xlsx

School

Hillsdale College *

*We aren’t endorsed by this school

Course

424

Subject

Accounting

Date

Jan 9, 2024

Type

xlsx

Pages

13

Uploaded by HighnessSeahorseMaster666

FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-5e4, Page 1 of 13, 12/15/2023, 19:38:06 Name: Solution Date: Instructor: Course: EXERCISE 10-5. Sales Budget Locksafe Company manufactures burglar-resistant commercial door locks. Recently, the company began selling locks on the Web, and the company expects sales to increase dramatically compared with the prior year. For the past year, 2011, unit sales were as follows: First quarter 23,000 units Second quarter 28,000 units Third quarter 27,000 units Fourth quarter 30,000 units Required: Assume that sales for each quarter in 2012 will be 25% higher than they were in 2011 and the selling price per lock is $15 Prepare a sales budget. Locksafe Company Sales Budget For the Year Ending December 31, 2012 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales for 2011 in units 23,000 28,000 27,000 30,000 108,000 Projected sales at 125% of prior year 28,750 35,000 33,750 37,500 135,000 Sales price per unit $15 $15 $15 $15 15 Budgeted revenue for 2012 $431,250 $525,000 $506,250 $562,500 2,025,000 Managerial Accounting , 4th Edition by James Jiambalvo Solving Managerial Accounting Problems Using Microsoft Excel for Windows Templates by Rex A Schildhouse
FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-5e4 ans, Page 2 of 13, 12/15/2023, 19:38:06 Name: Solution Date: Instructor: Course: EXERCISE 10-5. Sales Budget Locksafe Company manufactures burglar-resistant commercial door locks. Recently, the company began selling locks on the Web, and the company expects sales to increase dramatically compared with the prior year. For the past year, 2011, unit sales were as follows: First quarter 23,000 units Second quarter 28,000 units Third quarter 27,000 units Fourth quarter 30,000 units Required: Assume that sales for each quarter in 2012 will be 25% higher than they were in 2011 and the selling price per lock is $15 Prepare a sales budget. Locksafe Company Sales Budget For the Year Ending December 31, 2012 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Sales for 2011 in units 23,000 28,000 27,000 30,000 108,000 Projected sales at 125% of prior year 28,750 35,000 33,750 37,500 135,000 Sales price per unit $15 $15 $15 $15 $15 Budgeted revenue for 2012 $431,250 $525,000 $506,250 $562,500 $2,025,000 Managerial Accounting , 4th Edition by James Jiambalvo Solving Managerial Accounting Problems Using Microsoft Excel for Windows Templates by Rex A Schildhouse
Production Budget Data: Jan Feb Mar Apr Expected Sales (units) 13,000 14,900 19,400 21,900 Inventory, Jan 1 (units) 1,300 Desired ending inventory 10% of following month's expected sales VitaPup Production Budget Month Jan Feb Mar Total for the Quarter Current month requirement 13,000 14,900 19,400 47,300 add desired ending inventory 1,490 1,940 2,190 2,190 Total required 14,490 16,840 21,590 49,490 Less beginning inventory 1,300 1,490 1,940 1,300 Required Production 13,190 15,350 19,650 48,190
Ex 10-7e4 Production Budget Data: Jan Feb Mar Apr Expected Sales (units) 13,000 14,900 19,400 21,900 Inventory, Jan 1 (units) 1,300 Desired ending inventory 10% of following month's expected sales VitaPup Production Budget Month Jan Feb Mar Total Current month requirement 13,000 14,900 19,400 47,300 add desired ending inventory 1,490 1,940 2,190 2,190 Total required 14,490 16,840 21,590 49,490 Less beginning inventory 1,300 1,490 1,940 1,300 Required Production 13,190 15,350 19,650 48,190
FileName: dbd0e27c88777c761fa095edd505336b73483d3e.xlsx, Tab: E10-8e4 , Page 5 of 13, 12/15/2023, 19:38:06 Exercise E10-8 Direct Materials Purchases Budget Roehler Industrial has estimated that production for the next five quarters will be: Production Information Quarter 1, 2011 45,000 units Quarter 2, 2011 41,000 units Quarter 3, 2011 49,000 units Quarter 4, 2011 38,000 units Quarter 1, 2012 47,000 units Finished units of production require 6 pounds of raw material per unit. The raw material cost is $5.00 per pound. There are 54,000 pounds of raw material on hand at the beginning of quarter 1, 2011. Roehler desires to have 20% of next quarter's material requirements on hand at the end of each quarter. Required: Prepare quarterly direct materials purchases budgets for Roehler Industries for 2011. ROEHLER INDUSTRIES Direct Materials Purchases Budget For the Year Ending December 31, 2011
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help