Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you create an excel spreadsheet of CVP analysis based on the attached photos of Sales Budget & Labour Cost ? begin{tabular}{|c|c|c|c|c|} hline Labour Cost
Can you create an excel spreadsheet of CVP analysis based on the attached photos of Sales Budget & Labour Cost ?
\begin{tabular}{|c|c|c|c|c|} \hline Labour Cost & & & & \\ \hline & Fixed Cost (per year) & & Variable Cost (per meal per day) & \\ \hline Chef (x2) & $ & 80,300.00 & 22.00 & \\ \hline Dishwasher (x2) & $ & 65,700.00 & 18.00 & \\ \hline Server (x2) & $ & 80,300.00 & 22.00 & \\ \hline Cashier (x1) & $ & 40,150.00 & 11.00 & \\ \hline Manager (x1) & $ & 56,940.00 & 15.60 & \\ \hline Total & $ & 323,390.00 & 88.60 & \\ \hline & Pay rate (per hour) & & Pay rate (per day) & Hours worked (per day) \\ \hline Chef & $ & 22.00 & 110.00 & 5 \\ \hline Dishwasher & $ & 18.00 & 90.00 & 5 \\ \hline Server & $ & 22.00 & 110.00 & 5 \\ \hline Cashier & $ & 22.00 & 110.00 & 5 \\ \hline Manager & $ & 26.00 & 156.00 & 6 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started