Prepare an excel sheet for undergiven answers: please prepare excel sheet .... 5. Cost of Inventory Sold: Cost of jeans sold: 16 * $19 = $304 Cost of sweaters sold: 2 * $9 = $18 Cost of purses sold: 2 * $27 = $54 Cost of suits sold: 2 * $67 = $134 Total Cost of Inventory Sold = $304 + $18 + $54 + S134 = S510 6. Gross Margin: Gross Margin = Total Gross Sales - Total Cost of Inventory Sold Gross Margin = $1,418 - $510 = $908 7. Direct Expenses for the Month: Advertising: $200 Salaries: $500 Rent expenses: S200 Total Direct Expenses for the Month = $200 + $500 + 5200 = S900 Direct Expenses for the Day (assuming a 31-day month) = Total Direct Expenses for the Month / 31 Direct Expenses for the Day = $900 / 31 = $29.03 8. Indirect Expenses for the Month: Water: $75 Electricity: $89 Insurance: $60 Total Indirect Expenses for the Month = $75 + 589 + 560 = 5224 Indirect Expenses for the Day (assuming a 31-day month) = Total Indirect Expenses for the Month / 31 Indirect Expenses for the Day = $224 / 31 = $7.23 9. Total Operating Costs for the Day: Total Operating Costs = Direct Expenses for the Day + Indirect Expenses for the Day Total Operating Costs = $29.03 + $7.23 = $36.26 10. Profit for the Day: Profit = Gross Margin - Total Operating Costs Profit = $908 - $36.26 = $871.74
Prepare an excel sheet for undergiven answers:
please prepare excel sheet ....
5. Cost of Inventory Sold:
Cost of jeans sold: 16 * $19 = $304
Cost of sweaters sold: 2 * $9 = $18
Cost of purses sold: 2 * $27 = $54
Cost of suits sold: 2 * $67 = $134
Total Cost of Inventory Sold = $304 + $18 + $54 +
S134 = S510
6. Gross Margin:
Gross Margin = Total Gross Sales - Total Cost of
Inventory Sold
Gross Margin = $1,418 - $510 = $908
7. Direct Expenses for the Month:
Advertising: $200
Salaries: $500
Rent expenses: S200
Total Direct Expenses for the Month = $200 + $500
+ 5200 = S900
Direct Expenses for the Day (assuming a 31-day
month) = Total Direct Expenses for the Month / 31
Direct Expenses for the Day = $900 / 31 = $29.03
8. Indirect Expenses for the Month:
Water: $75
Electricity: $89
Insurance: $60
Total Indirect Expenses for the Month = $75 + 589 +
560 = 5224
Indirect Expenses for the Day (assuming a 31-day
month) = Total Indirect Expenses for the Month / 31
Indirect Expenses for the Day = $224 / 31 = $7.23
9. Total Operating Costs for the Day:
Total Operating Costs = Direct Expenses for the Day
+ Indirect Expenses for the Day
Total Operating Costs = $29.03 + $7.23 = $36.26
10. Profit for the Day:
Profit = Gross Margin - Total Operating Costs
Profit = $908 - $36.26 = $871.74
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
