Question
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
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%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started