Excel 2021 in practice – ch 3 independent project 3-4

Ace your studies with our custom writing services! We've got your back for top grades and timely submissions, so you can say goodbye to the stress. Trust us to get you there!


Order a Similar Paper Order a Different Paper

For this assignment, all you have to do is follow the instructions to complete the Excel document.

The instructions and start file are attached. 

BreakEven

Classic Gardens and Landscapes
Break Even Point in Units
Based on Sales Price
Sales Price $250
Assigned Variable Cost $125
Fixed Cost for Department $15,000
Per Unit Margin (Profit) $125
Break Even Point 120
# Sold Fixed
Cost
Total
Variable
Costs
Total
Costs
Dollar
Sales
Profit
0 $15,000 $0 $15,000 $0 -$15,000
50
75
100
125
150
175
200
225
250

Gross Margins

Classic Gardens and Landscapes (CGL)
Gross Margin by Department, Six Months
Departments April May June July August September Total
Lawn Maintenance $4,500 $5,200 $6,500 $8,400 $8,500 $10,000 $43,100
Tree & Shrubbery $5,000 $3,400 $3,500 $6,500 $12,000 $12,500 $42,900
Patio and Furniture $12,000 $9,000 $15,500 $13,500 $15,000 $12,450 $77,450
Fountains and Irrigation $10,000 $5,500 $6,500 $7,200 $7,000 $8,000 $44,200
Design Consulting $5,000 $5,200 $3,500 $4,500 $3,500 $8,000 $29,700
Total Gross Margin $36,500 $28,300 $35,500 $40,100 $46,000 $50,950 $237,350
Writerbay.net

Looking for top-notch essay writing services? We've got you covered! Connect with our writing experts today. Placing your order is easy, taking less than 5 minutes. Click below to get started.


Order a Similar Paper Order a Different Paper