Fabulous Accessories Inc. manufactures wallets and handbags that are sold in two regions, the East and West regions.

ESTIMATED SALES

Fabulous Accessories estimates the following sales volumes and prices for 2023:

	East Region Sales Volume	West Region Sales Volume	Unit Selling Price
Wallets	287,000	241,000	$12
Handbags	156,000	123,600	25

*Sales fluctuate seasonally. Quarterly sales are projected as 15%, 25%,20%, and

40% in the first, second, third and fourth quarter, respectively.

Fabulous Accessories Inc. expects the following inventories of wallets and handbags:

	Est. Inventory 01/01/2022	Estimated Inventory 12/31/2022
Wallets	15,000	15,840
Handbags	8,000	8,388

Assume the estimated beginning inventory is 20% of that quarter estimated sales. (Hint: the estimated desired ending inventory for each quarter is the estimated beginning inventory of the following quarter)

Prepare the following budgets for the coming year (2023) using Excel

1. Construct a sales budget for the coming year. Show total sales by quarter and in total for the year

2. Construct a production budget for the coming year. Show total units produced by quarter and in total for the year.