15 Oct For this assignment, all you have to do is follow the instructions to complete the Excel document. The instructions and start file are attached.?-ClassicGardens-03.xlsxExcel2021InPra
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 |
