Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with forecasting the following: Forecast and Financial Data begin{tabular}{|c|c|c|c|} hline & A & B & C hline 1 & multicolumn{3}{|l|}{ Breakeven Carwashes

Please help with forecasting the following:

image text in transcribedimage text in transcribedimage text in transcribed Forecast and Financial Data \begin{tabular}{|c|c|c|c|} \hline & A & B & C \\ \hline 1 & \multicolumn{3}{|l|}{ Breakeven Carwashes } \\ \hline 2 & & Current & Upgrade \\ \hline \begin{tabular}{l} 3 \\ 4 \end{tabular} & Revenue Per Carwash & & \\ \hline 5 & Variable Costs & & \\ \hline 6 & Utilities & & \\ \hline 7 & Chemicals & & \\ \hline 8 & Maintenance & & \\ \hline 9 & Labor & & \\ \hline 10 & Total Variable Costs & & \\ \hline \begin{tabular}{l} 11 \\ 1/2 \end{tabular} & Contribution Margin & & \\ \hline 13 & Contribution Margin \% & & \\ \hline 15 & FixedCosts & & \\ \hline 16 & Owners' Salaries & & \\ \hline 17 & Daughter/Son Salary & & \\ \hline 18 & Insurance & & \\ \hline 19 & Operating Costs & & \\ \hline 20 & Advertising & & \\ \hline 21 & Depreciation & & \\ \hline 22 & Total Fixed Costs & & \\ \hline 24 & Breakeven Carwashes & & \\ \hline 25 & Fixed Costs/Contribution Margin Per Carwas & & \\ \hline 26 & Total Fixed Costs & $0 & $0 \\ \hline \begin{tabular}{l} 27 \\ cu \\ 29 \end{tabular} & \begin{tabular}{c} Contribution Margin \$\$ Per Car Wash \\ Breakeven Car Washes \end{tabular} & & \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{2}{|c|}{ Breakeven Sales in Sales Dollars } \\ Calculation: Breakeven Carwashes x Revenue per Carwash \\ Breakeven Car Washes \\ Revenue Per Car Wash (\$\$) \\ Breakeven Dollars \\ Alternative Method for Breakeven Carwashes using CM \\ Fixed Costs/Contribution Margin\% \\ Fixed Costs \\ Contribution Margin Percent \\ Breakeven Dollars \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen

9th Edition

1265672008, 978-1265672003

More Books

Students also viewed these Accounting questions