Answered step by step
Verified Expert Solution
Link Copied!

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 ?image text in transcribed

image text in transcribed \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

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

Step: 3

blur-text-image

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

A Textbook Of Cost And Management Accounting

Authors: Arora

10th Edition

9789325956209

More Books

Students also viewed these Accounting questions