60.1K
Verified Solution
Link Copied!
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}
Answer & Explanation
Solved by verified expert