Strategy
2 years ago
60
Exam500895-PPMCExcelSpreadsheet.xlsx
- reading_assignment_core_1.html.zip
Exam500895-PPMCExcelSpreadsheet.xlsx
Step 2
| Calculation of First Year Break Even Points | Calculation of First Year Break Even Points | |||||||||||||||||||||
| Note | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | 1st | 1st | 2nd | 3rd | 4th | 1st | ||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year | Qtr | Qtr | Qtr | Qtr | Year | |||||
| Stores | ||||||||||||||||||||||
| Multiply by 200 carts | ||||||||||||||||||||||
| Total Carts | ||||||||||||||||||||||
| Multiply by Revenue per cart | ||||||||||||||||||||||
| Total Revenues | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Variable Costs (VC) | ||||||||||||||||||||||
| Amortization (2 year S/L)
Burcicki, Jim: While amortization in its normal sense would be considered a FC, it is considered a VC here because the number of carts is variable even though we are using an average of 200 carts as the basis. |
2 | |||||||||||||||||||||
| Printing | 3 | |||||||||||||||||||||
| Replacement (even distribution) | 4 | |||||||||||||||||||||
| Cart Rental (10% Revenue) | 5 | |||||||||||||||||||||
| Mktg. Sales & Comm. | 6 | |||||||||||||||||||||
| Grocery Store Operations | 7 | |||||||||||||||||||||
| Total VC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Contribution Margin (CM) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| CM per Unit/Cart | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Fixed Costs (FC) | ||||||||||||||||||||||
| Accounting & Audit | 8 | |||||||||||||||||||||
| Advertising (even distribution) | 9 | |||||||||||||||||||||
| Auto Lease | 10 | |||||||||||||||||||||
| Bank Charges | 11 | |||||||||||||||||||||
| Entertainment & Promotion | 12 | |||||||||||||||||||||
| Insurance | 13 | |||||||||||||||||||||
| Legal | 14 | |||||||||||||||||||||
| Management Fees | 15 | |||||||||||||||||||||
| Office & Sundry | 16 | |||||||||||||||||||||
| Public Relations | 17 | |||||||||||||||||||||
| Rent | 18 | |||||||||||||||||||||
| Salaries & Benefits | 19 | |||||||||||||||||||||
| Stationary & Printing | 20 | |||||||||||||||||||||
| Telephone & Faxc | 21 | |||||||||||||||||||||
| Travel & Accommodation | 22 | |||||||||||||||||||||
| Total FC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Total Expenses (VC + FC) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Net Operating Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Break Even Point in terms of carts | ERROR:#DIV/0!
Burcicki, Jim: The Formula Method - Managerial Accounting, 15th ed., Page 201 BE (Carts) = Total FC / (CM per Unit/Cart) |
ERROR:#DIV/0!
Burcicki, Jim: The Formula Method - Managerial Accounting, 15th ed., Page 201 BE (Carts) = Total FC / (CM per Unit/Cart) |
||||||||||||||||||||
| Break Even Point in terms of stores | ERROR:#DIV/0!
Burcicki, Jim: The Equation Method - Managerial Accounting, 15th ed., Page 201 Break Even = Q Unit CM = CM / Total # of Stores Profit = Unit CM x Q - Fixed Expense |
Burcicki, Jim: The Formula Method - Managerial Accounting, 15th ed., Page 201 BE (Carts) = Total FC / (CM per Unit/Cart) |
ERROR:#DIV/0!
Burcicki, Jim: The Equaion Method - Managerial Accounting, 15th ed., Page 201 Break Even = Q Unit CM = CM / Total # of Stores Profit = Unit CM x Q - Fixed Expense |
|||||||||||||||||||
|
Burcicki, Jim: Will cost 15k so I am assuming the expense is being accrued and therefore expensed in December as an adjusting entry. |
Burcicki, Jim: The author expenses the 10k in January. However, it states that the 10k will be purchased during the first quarter - first three months - in sufficient quantities to last the entire year. This should be a prepaid and then expensed during the year. With no set amoutns, I assumed an even distribution throughout the year. |
Burcicki, Jim: While amortization in its normal sense would be considered a FC, it is considered a VC here because the number of carts is variable even though we are using an average of 200 carts as the basis. |
Burcicki, Jim: The Formula Method - Managerial Accounting, 15th ed., Page 201 BE (Carts) = Total FC / (CM per Unit/Cart) |
reading_assignment_core_1.html.zip
This file is too large to display.View in new window
other Questions(10)
- Hegemony? What Is It? Where Can I Find It?
- The Space Age Furniture Company Problem
- POST FOR HANDSHAKE
- If you are using the Blackboard Mobile Learn iOS App, please click "View in Browser" Click the link above to submit your assignment. Students, please view the "Submit a Clickable Rubric Assignment" in the Student Center. Instructors, training on how to gr
- help
- Ethics
- Strayer BUS 310 Ch 01 MCQs
- 2. Incident investigation: What analysis errors might be caused by an incorrect timeline? Share an example of how an error in the timeline can affect your analysis.
- Sketch the graph of the equation. Identify the x-intercepts of the graph(s).
- Use the properties of real numbers to simplify the following expressions: