Description
You are required to research costs items at www.costcobusinessdelivery.com and breakdown all bulk items down to a unit cost. Each Excel worksheet provided in the attached workbook contains blank, yellow highlighted cells that require you to completely fill in costs or link costs through Excel formulas. Amount totals for sales (# sold) and payroll for the P&L will be based on "what-if" analysis.
You are required to use the worksheet below:
- Week 4 - Final Project Costing Worksheets - Excel Document (285 KB)
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached. Please let me know if you have any questions or need revisions.
Menu Items
Double-Double
Cheeseburger
$3.45
$2.40
Instructions
This tab is asking you just to input the menu price for each of the items above. Later on, w
automatically, so we can do some analyses.
This analysis will assist you in computing the costs and revenues necessary to
make critical production decisions.
Hamburger
French Fries
$2.10
$1.60
h of the items above. Later on, we'll see these menu prices transferred forward
Food Inventory
Tip: Use the Costco business site to approximate the costs below. The yellow cells
you to enter the data and/or calculate the cost. This will flow into the Cost Breakd
tab.
Meat Inventory
Item
Beef
Recipe
Sandwiches
Amount
4 lb
Produce Inventory
Item
Lettuce
Potatoes
Tomatoes
Yellow Onions
Recipe
Sandwiches
French Fries
Sandwiches
Sandwiches
Amount
5 lb
50 lb
25 lb
10 lb
Dairy Inventory
Item
Cheese
Recipe
Sandwiches
Amount
60 ct
Other Inventory
Item
Buns
Dressing (Sauce)
Frying Oil
Recipe
Sandwiches
Sandwiches
French Fries
Amount
24 ct
1 gal
35 lb
Tip: Notice that we're focusing on the food related inventory. In-N-Out does have beverages, including soft drinks and
milkshakes. They also have paper bags, napkins, utensils, condiments, salt, pepper, etc… There is also additional options l
"animal style" and "carmelized onions." For sake of our high-level analysis, we're going to focus on the food related produ
and ordering the burgers without any of those enhancements. We will touch on the condiments, pepper and salt in the M
Analysis. Also, for this exercise, let's assume that we can use "Thousa...