Assignment 3: Create a Spreadsheet

NEED TO HELP A SPREADSHEET THE MATH IS DONE

A) 30 points

Lincoln Park small retail store is reviewing their financial performance after one month's 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 theSales Revenue per Month based upon the details provided.

$27 x 1,245 = $33,615

Part B :

Calculate the Cost of Goods Purchasedbased upon the details provided.

Assignment # 3 ---continued---

B) 30 Points

Lincoln Park small retail store is reviewing their financial performance after one month's 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.

$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%