BISTRO DETAILED OPERATIONAL COST

Bistro Detailed Operational Cost
Order Description
Write a 1 page Detailed operational cost sheet using the attached example and instructions. The information for this work is also attached on the excel spread sheet title Weekly Sales under the tab Pro Forma P& L ounce you scroll over to the right ounce opened. This Detailed operational cost sheet should be centered for Bistro and bakery business plan. If any additional info is needed regarding this let me know.
Break down your Operational Costs into the following categories: Variable, Fixed, Interest, and Depreciation (must include yearly figures as well as a monthly average for each category)
Below is a brief breakdown for each category.

Detailed Operational Costs
It costs you money to run your small business. You have marketing costs and administrative costs, and together these make up your operational costs. When you learn to examine these costs in detail, you can find ways to cut costs and evaluate the effectiveness of the dollars you spend to keep your business going. Divide your operational costs into categories so you can understand how you incur them each month.
Variable Costs
You have several expenses that may change from week to week or month to month. These costs go up when you produce or sell more. Examples include production wages, raw materials and shipping costs. You can track these over a one-year period and divide by 12 to find an average variable cost. Whenever you decide to ramp up production or offer sales bonuses, be aware that you will increase your variable costs.
Fixed Costs
Several of your operational costs remain fixed each month. These include rent or mortgage payments, salaries for non-production personnel, insurance, lease payments, Internet hosting, phone service and building maintenance. Think of your fixed costs as the expense for opening your doors each day. You incur fixed costs no matter how much or how little you manufacture or sell. Look for ways to increase sales while cutting fixed costs and you can build company profitability.
Interest
Although you might think of your interest expenses as “fixed” because you know what they will be each month, you should look at them as costs you incur because you borrow money to grow your business. Track your interest on loans, overpublish protection, company credit cards and unpaid balances you owe to vendors. Categorize these as interest costs when figuring your total operational costs. Whenever you decide to fund an expansion with borrowed money, you will know you are planning to increase your interest portion of your operational costs.
Depreciation
Part of your operational expenses includes the value you lose each month on buildings, equipment, vehicles and office furniture. This depreciation counts as an ongoing operational expense and should be included when you do your accounting each month. The Internal Revenue Service allows you to write off depreciation on your annual taxes because the lost value in your assets costs you when you finally sell them.
Appetizer Soup Salad Entrée Dessert Bev. Check Total
Guest Order MP FC MP FC MP FC MP FC MP FC MP FC
1 Flavia Goddard Artichoke and Spinach Dip, Shrimp Pasta, Sprite, Mango cheesecake, sprite $4.00 $4.30 $8.95 $7.51 $6.00 $0.66 $1.50 $1.25 $20.45
2 Nicole Simpson Green Salad, Mediterranean Chicken, Green Beans, Coke 4.00 3.37 16.00 8.53 1.50 1.25 $21.50
3 Karrie Johnson Shrimp Pasta, Corn Mach Choux, Root Beer, Better than sex cake 8.95 7.51 4.95 0.94 1.50 1.25 $15.40
4 Tiffinay Martin Fried Pickles, Smothered Pork Chops, Collard Greens, Coke 4.00 2.05 9.95 7.12 1.50 1.25 $15.45
5 Carl Buck artichoke and Spinach Dip, Bacon Cheeseburger, Fries, Coke, Better than sex cake 8.00 4.30 12.00 3.98 4.95 0.94 1.50 1.25 $26.45
6 Marlon Anthony Cobb Salad, Diet Coke, Herbed Steak, Green Beans, Mango cheesecake 10.95 11.66 22.95 4.95 6.00 0.66 1.50 1.25 $41.40
7 Bianca Miller Strawberry salad, Coke, Carrot cupcakes 9.95 1.77 3.50 4.41 1.50 1.25 $14.95
8 David Grant Bacon cheeseburger, Fries, Root beer 12.00 3.98 1.50 1.25 $13.50
9 Jason Miller Island Jerk Chicken, Green Beans, Coke, 9.95 3.95 1.50 1.25 $11.45
10 Laurine Watkins Grilled Chicken Caesar Salad, Water 8.95 9.04 1.50 1.25 $10.45
11 Robin Johnson Smothered Pork Chops, corn mach choux, sprite, mango cheesecake 9.95 7.12 6.00 0.66 1.50 1.25 $17.45
12 Michael Hughes Savory Herbed Steak, Green Beans, Coke 22.95 4.59 1.50 1.25 $24.45
13 James Johnson Four Cheese Garlic Bread, Shrimp Pasta, Coke 4.00 2.78 8.95 7.51 1.50 1.25 $14.45
14 James Yarborough Island Jerk Chicken, coke, collard greens, Carrot cake 9.95 3.95 3.50 4.41 1.50 1.25 $14.95
15 Andrew Carr Island Jerk Chicken, Collard Greens, Diet Coke, Carrot cake 9.95 3.95 3.50 4.41 1.50 1.25 $14.95
16 Larry Delgado Flavias Gumbo, Coho Salmon, Corn mach choux, Fanta, 12.00 13.84 16.00 1.73 1.50 1.25 $29.50
17 Rebecca Lust Artichoke and spinach dip, Mediterranean chicken, green beans, pound cake, coke 4.00 4.30 16.00 8.53 6.95 6.22 1.50 1.25 $28.45
18 Jeneaury Placa codd Salad, Grilled Prawns, green beans, Diet coke, better than sex cake 10.95 11.66 14.00 3.32 4.95 0.94 1.50 1.25 $31.40
19 Eric Melendez Fried pickles, Bacon Cheeseburger, Coke, 2.00 2.05 12.00 3.98 1.50 1.25 $15.50
20 Walter Trotter Fried Pickles, Island Jerk Chicken, Diet coke 2.00 2.05 9.95 3.95 1.50 1.25 $13.45
21 Simone Bowman Fried Green tomatoes, Mediterranean chicken, green beans, fanta, 3.50 1.14 16.00 8.53 1.50 1.25 $21.00
22 Khia Woods Artichoke and spinach dip, Grilled Prawns, corn mach choux, pound cake, coke 4.00 4.30 14.00 3.32 6.95 6.22 1.50 1.25 $26.45
23 Jessica Delgado Caesar Salad, shrimp pasta, vegetable soup, pound cake, sprite 8.95 9.04 8.95 7.51 6.95 6.22 1.50 1.25 $26.35
24 Geraldine Weekes Four Cheese Garlic Bread, Coho Salmon, green beans, Diet coke, 2.50 2.78 16.00 1.73 1.50 1.25 $20.00
25 Luke ONeil Leek and Potato soup, Shrimp pasta, Pound cake, Sprite 9.95 12.95 8.95 7.51 6.95 6.22 1.50 1.25 $27.35
26 Cabie Fontenel Fried Pickles, Jerk chicken, collard greens, Diet coke, 3.00 2.05 9.95 3.95 1.50 1.25 $14.45
27 Stephen Goddard Chicken and sausage gumbo, Coho Salmon, corn mach choux, sprite, pound cake 12.00 13.84 16.00 1.73 6.95 6.22 1.50 1.25 $36.45
28 Wanda Jones Caesar Salad, Bacon Cheeseburger, Fries, Coke 8.95 9.04 12.00 3.98 1.50 1.25 $22.45
29 Timothy Bodley Fried pickles, Caesar Salad, Shrimp pasta, Coke, mango cheesecake 4.00 2.05 8.95 9.04 8.95 7.51 6.95 6.22 1.50 1.25 $30.35
30 Anthony Carter Cobb Salad, fried pickles, Herbed steak, green beans, root beer, pound cake 4.00 2.05 10.95 11.66 22.95 4.59 6.95 6.22 1.50 1.25 $46.35
31 Monica Strovell Cobb salad, smothered pork chops, collard greens, fanta, pound cake 10.95 11.66 9.95 7.12 6.95 6.22 1.50 1.25 $29.35
32 Derrick Dole Fried pickles, Bacon Cheeseburger, Fries, Coke, 4.00 2.05 12.00 3.98 1.50 1.25 $17.50