Question

Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk discounters and sells the sunglasses in the mall kiosks. Shamrock is in the process of budgeting for the coming year and has projected sales of $410,000 for January, $490,000 for February, $650,000 for March, and $690,000 for April. Shamrock’s desired ending inventory is 30 percent of the following month’s cost of goods sold. Cost of goods sold is expected to be 45 percent of sales.

Required:

Compute the required purchases for each month of the first quarter (January–March).

	January February March Required Purchases

Answer 1

If you need further help, please let me know

S No	Particulars	January	February	March	April (only for March calculation)
A	Sales	$ 410,000	$ 490,000	$ 650,000	$                                          690,000
B	Cost of Goods Sold (A X 45%)	$ 184,500	$ 220,500	$ 292,500	$                                          310,500
C	Ending Inventory (30% X Next month COGS)	$   66,150	$   87,750	$   93,150
D	Beginning Inventory	$   55,350	$   66,150	$   87,750
E	Purchases (B + C - D)	$ 195,300	$ 242,100	$ 297,900