Assignment 3: Create a Spreadsheet

HAVE TO CREATE A SPREADSHEET WITH INFORMATION LISTED.

A) 30 points Lincoln Park small retail store is reviewing their financial performance after one months worth of operation. Based upon the details listed below, complete the calculations as requested. SALES: Average Sell Price $27.00 Total Units Sold per Month 1,245 COSTS: Average Cost per Unit $12.50 Total Units Purchased per Month 1,525 Monthly Rent + Utilities Costs $2,750 Marketing Costs per Month $645 Labor Costs per Month $1,450

Part A : Calculate the Sales Revenue per Month based upon the details provided. $27 x 1,245 = $33,615

Part B : Calculate the Cost of Goods Purchased based upon the details provided.

Assignment # 3 ---continued--- B) 30 Points Lincoln Park small retail store is reviewing their financial performance after one months worth of operation. Based upon the details listed below, complete the calculations as requested. SALES: Average Sell Price per Unit $27.00 Total Units Sold per Month 1,245 COSTS: Average Cost $12.50 Total Units Purchased per Month 1,525 Monthly Rent + Utilities Costs per Month $2,750 Marketing Costs per Month $645 Labor Costs per Month $1,450 $12.50 x 1,525 = $19,062.5

Part C :5 points Calculate Gross Margin per Month in both Dollars ($$) and Percentage (%) based upon the details provided. Part C: $33,6150- $19,062.5 = $14,552.5 = 43.3%

Part D : 5 points Calculate Profit per Month in both Dollars ($$) and Percentage (%) based upon the details provided. $19,062.5+ $645+ $1,450+ $2,750 = $23,907.5 ppm = $33,615- $23,907.5 = $9,707.5 = 28.9%