Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Preparing Sales Budget and Production Budget The sales department of Macro Manuf

ID: 2589505 • Letter: P

Question

Preparing Sales Budget and Production Budget The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is $25 per unit. The desired ending inventory on June 30 is 2.000 units, and the expected beginning inventory on June 1 is 3,000 units. Hide a. Prepare a sales budget for June Macro Manufacturing Co. Sales Budget For the Month Ended June 30,20- egion Unit Sales Volume Unit Selling Price Total Sales East West Total Hide

Explanation / Answer

Requirement a: Sales Budget: Macro Manufacturing Co. Sales Budget For the Month ended June 30, 20-- Region Unit Sales Volume Unit Selling Price Total Sales East 15000 25 375000 West 5000 25 125000 Total 20000 25 500000 Requirement b: Production Budget: Macro Manufacturing Co. Production Budget For the Month ended June 30, 20-- Units Sales 20000 Ending Inventory 2000 Total 22000 Beginning Inventory 3000 Total Production 19000