Expected quarterly unit sales for tents at Sandys Camping Gear are 7,500, 8,800, 3,200, and 2,900 for the next two years. At the start of the current year, inventory of finished tents on hand is 750 tents. Sandys has a desired ending inventory of 20 percent of next quarters sales.

Create the production budget in numbers of tents for quarters one through four for the current year.

This is what I have so far, I need help completing the question

SANDYS CAMPING GEAR

Budgeted Production

Q1 Q2 Q3 Q4

Expected sales 7,500 8,800 3,200 2,900

Add: Desired ending inventory

Less: Beginning inventory 750

Production budget in number of tents 6,750 8,800 3,200 2,900