[moonkhan209]

More than One Cost Driver

Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made. Data concerning the pizzeria's costs appear below:



Fixed Cost
Per Month
Cost per
Pizza
Cost per
Delivery

Pizza ingredients


$
1.8



Kitchen staff
$
4,620





Utilities
$
490
$
1



Delivery person




$
3.3

Delivery vehicle
$
350


$
1

Equipment depreciation
$
232





Rent
$
1,660





Miscellaneous
$
790
$
1




--------------------------------------------------------------------------------
In November, the pizzeria budgeted for 2,200 pizzas at an average selling price of $16 per pizza and for 190 deliveries.

Data concerning the pizzeria's operations in November appear below:



Actual Results

Pizzas

2,220

Deliveries

180

Revenue
$
17,200

Pizza ingredients
$
3,285

Kitchen staff
$
5,330

Utilities
$
900

Delivery person
$
430

Delivery vehicle
$
700

Equipment depreciation
$
110

Rent
$
1,820

Miscellaneous
$
920


--------------------------------------------------------------------------------

Required:

Prepare a flexible budget performance report that shows both activity variances and revenue and spending variances for the pizzeria for November. (Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e. zero variance). Input all amounts as positive values. Omit the "$" sign in your response.)

I just need help how to find the revenue activity variance and spending variences for pizza. Please tell me how I can find that.
:confused::confused::confused::confused::confused: :confused:

[haider78605]

Hi
By what time you required the help I mean what is your deadline for the answer?

[moonkhan209]

hi
by what time you required the help i mean what is your deadline for the answer ??

In about 3 or 4 days.

[haider78605]

OK NP I will try my best to help you out with in the given time :)

[moonkhan209]

ok NP i will try my best to help you out with in the given time period :)

Why not right now,Is it possible to tell me today or not?

[haider78605]

I will try to answer it by tomorrow

[haider78605]

Hi
I got it I will provide you the answer tomorrow I have started working on it

[haider78605]

Moon khan ask me help desk1 .xls

Hi I have provided the answer if you have any further queries feel free to ask

Regards

[morgaine300]

No wonder you were wanting paid. You're just going around doing people's work for them. It's not fun spending all that time for free when you don't even know if the student did any work, is it?