ch10 Homework
.xlsx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
280
Subject
Business
Date
Apr 3, 2024
Type
xlsx
Pages
6
Uploaded by alympakes
Chapter 10
Q 2
Chapter 10, Question 4
Goal Value Analysis Data Item
Fajita Plate
0.38
147
$12.95
0.28
Enchilada Dinner
0.35
200
$9.95
0.28
Menudo
0.25
82
$6.95
0.28
Mexican Salad
0.30
117
$7.95
0.28
Taco Dinner
0.26
225
$5.95
0.28
Chalupa Dinner
0.28
125
$8.95
0.28
Burrito Dinner
0.33
168
$9.95
0.28
0.32
152
$8.95
0.28
Goal Value Analysis Results Item
Enchilada Dinner
0.35
200
$9.95
0.28
Taco Dinner
0.26
225
$5.95
0.28
Burrito Dinner
0.33
168
$9.95
0.28
Fajita Plate
0.38
147
$12.95
0.28
Chalupa Dinner
0.28
125
$8.95
0.28
Mexican Salad
0.30
117
$7.95
0.28
Menudo
0.25
82
$6.95
0.28
b. Help Garikai calculate the Goal Value for the chulupa dinner if he lowers the selling pri
Results of Changes Made to Chalupa Dinner
a. Using the following goal value analysis data, help Garikai analyze the restaurant's menu items. Food Cost %
(in decimal form)
Number Sold
Selling Price
Variable Cost %
(in decimal form)
Overall Menu (Goal Value)
After computing the following goal values, sort (in descending rank order) by goal value.
include the overall menu in the appropriate rank order. Spreadsheet hint: Calculate the g
placing the ENTIRE goal value formula for each item in the Goal Value column as follows
%) x item popularity x selling price x (1 - (variable cost % + food cost %)). The table will n
correctly if partial calculations for goal value exist in columns A, B, C, or D. For example,
calculate (1 - food cost %) in the A column or (1- (variable cost % + food cost %)) in the D
"A"
Food Cost %
(in decimal form)
"B"
Number Sold
"C"
Selling Price
"D"
Variable Cost %
(in decimal form)
Chapter 10
Q 2
Item
Chalupa Dinner
0.29
150
$8.55
0.29
"A"
Food Cost %
(in decimal form)
"B"
Number Sold
"C"
Selling Price
"D"
Variable Cost %
(in decimal form)
If he makes these changes, will the chalupa dinner meet or exceed the overall menu goal value? Should
these changes?
Answer: He should make the changes because he will then be greater than the menu goal.
Chapter 10
Q 2
Goal Value
478.6
455.7
436.8
401.3
354.4
273.5
200.9
ice.
. Be sure to goal values by s: (1 - food cost not sort , DO NOT D column.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
4. What is FIFO method?
5. what is Average cost
method?
arrow_forward
Question 2 needed
This is just for knowledge purposes
arrow_forward
a. Meaning of ABC analysis?
arrow_forward
Problem 1 Dr. Song will go to McDonald's for dinner tonight. After studying operations
research, he feels that he should at least be "smart" enough to figure out the way he eats it. Let's
build a model to determine what to eat at McDonald's.
QP
AD
BM
FF
MC
FR
SM
1M
OJ Required
Cost
3.79
4.49
3.99
3.79
1.29
1.79
1.19
1.00
1.89
Prot
28
24
25
14
31
3
15
1
55
VitA
15
15
6
8
4
10
2
100
VitC
10
2
15
15
4
120
100
Calc
30
20
25
15
15
20
30
2
100
Iron
20
20
20
10
8
15
100
Cals
510
370
500
370
400
220
345
110
80
2000
Carb
34
33
42
38
42
26
27
12
20
350
The tables gives the menu (Quarter Pounder, Angus Deluxe, etc.) along with their unit cost (in
$) and amount of nutrients contained (Protain, Vitamin A, etc.) The last column of the table gives
the daily required amount of nutrients suggested by Dr. Song's doctor. Suppose Dr. Song aims to
minimize the cost of his dinner, while he wants to satisfy all the nutrient requirements. Formulate
this problem as a linear programming model, and solve it in…
arrow_forward
Question 3&4
This is just for knowledge purposes
arrow_forward
Given information below
profit in $
pumps
labor hours
feet of tubing
Aqua-Spa (x1) Hydro-Lux (x2)
1
2
MAX
S.T.
350
1
9
12
300
1
6
16
x₁ = # of Aqua-Spa hot tubs to produce
x₂ = # of Hydro-Lux hot tubs to produce
350x1 + 300x2
x1 + x₂ ≤ 200
9x1+6x2 ≤ 1566
12x₁ +16x2 ≤2880
*120
X220
total
950
3
21
44
RHS
200
1566
2880
(total profit in $)
(pumps)
(labor hours)
(feet of tubing)
Q5.1. How many resources were used to produce the optimal solution?
arrow_forward
Required information
Skip to question
George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks:
Week
Units
Total Etching Cost
1
9
$ 21
2
12
25
3
13
30
4
9
20
5
11
25
6
18
34
72
$ 155
For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week.
2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week.
2-b. Express these estimates in the form Y = a + bX.
arrow_forward
Mc
Graw
Hill
Home Page - JagApp
Week 12 - Midterm #2 (100 points) i
17
Consider the following list of accounts:
• Cash
•
Prepaid Expense
•
Service Revenue
8
points
01:16:23
• Salaries Expense
•
Accounts Payable
Equipment
• Retained Earnings
•
Common Stock
•
Dividends
Х
סוי
M Question 17 - Week 12 - Midterm #2 (100 points) - Connect
How many of these accounts have a normal debit balance?
Numeric Response
arrow_forward
Please do not give solution in image formate thanku.
arrow_forward
Subject: Logistic Manangement
Q#1) What are the defination of Verticle and Horizontal Integration, explain with examples of each?1.1: Definition1.2: Examples
arrow_forward
Q3 Lab2
Subject: Production and operation management
Please answer ASAP
arrow_forward
Q1
(a) Looking at the Sensitivity table above explain briefly by answering if the demand by any of these the classes is not satisfied.
(b) Write down how many bookings the hotel should accept in each rental class?
arrow_forward
PLEASE ANSWER QUICKLY
arrow_forward
Q3. Explain two strategies that a firm can use to reduce competition from existing competitors.
Pleases expain with the diagram
arrow_forward
Q2. Explain strategic implications of BCG matrix
model.
arrow_forward
Question 3
Regular output capacity is 130 units per month. Regular cost per unit = K600. Overtime cost per unit
K900. Beginning inventory is 0 units. We have the forecast of engine demand shown below:
a) Develop a chase plan that matches the forecast. Calculate the cost of the plan.
b) Develop a level plan that uses inventory to absorb fluctuations. Compare the costs of the level
plan to the costs of the chase plan from Part (a). Inventory carrying cost per unit per month = 20.
Backlog cost per unit per month = K900. There should be no backlog in the final month.
Month
Forecast
1
120
2
3
135 140
4
120
End of assignment 1
5
125
6
125
7
140
=
8
135
Total
1,040
arrow_forward
4
arrow_forward
1.
arrow_forward
The manager of a bulk foods establishment sells a trail mix for
$9
per pound and premium cashews for
$14
per pound. The manager wishes to make an
200-pound
trail mix-cashew
mixture that will sell for
$11
per pound. How many pounds of each should be used?
Question content area bottom
Part 1
A.
80
lb of trail mix
120
lb of cashews
B.
100
lb of trail mix
100
lb of cashews
C.
140
lb of trail mix
60
lb of cashews
D.
120
lb of trail mix
80
lb of cashews
arrow_forward
QUESTION #1
Mrs. Johnson, the owner of a small manufacturing business has patented a new device for
kitchen appliance. Before trying to commercialize the device and add it to her existing product
line, the she wants reasonable assurance of success. Variable costs are estimated at $8 per unit
produced and sold. Fixed costs are about $60,000 per year.
a. Forecasted sales for the first year are 15,000 units if the price is reduced to $20. With this
pricing strategy, what would be the product's total contribution to profits in the first year?
b. If the selling price is set at $30, how many units must be produced and sold to break even?
Use both algebraic and graphic approaches
arrow_forward
Requirement
Show your working calculation
arrow_forward
Q The manager of a fast food restaurant featuring hamburgers is adding salads to the menu. For each of the two new options, the price to the customer will be the same. The MAKE option is to install a salad bar stocked with vegetables, fruits and toppings and let the customer assemble the salad. The salad bar would have to be leased and a part-time employee hired. The manager estimates the fixed cost at $12000 and variable costs totalling $1.5 per salad. The BUY option is to have pre-assembled salads available for sale. They would be purchased from a local supplier at $2 per salad. However, offering pre-assembled salads would require installation and operation of additional refrigeration, with fixed annual cost of $2400.
What is the rational decision if A) the manager expects to sell 25000 salads per year and B) the manager expects to sell 18000 salads
arrow_forward
answer for 3.2, 4.1 & 4.2 only
This is for knowledge purposes
arrow_forward
Question 2
Mike is a first year university student who is trying to understand his financial situation. Mike currently lives 1.5 miles away from campus. He works part time in a retail centre that pays him £800 per month. Mike saves £200 out of the part time job pay for his further education plan.
a). As to the below Travel Expenses table published by the Students’ Union, 185 students were randomly selected to help understand the travel expenses and distance to campus. What’s the probability for Mike to spend over £10 on journeys to campus?
Distance to Campus (miles)
Amount spent, £
0.1 to 0.25
0.26 to 1.0
Over 1.0
0 – 4.99
35
26
10
5.00 – 9.99
18
39
20
10.00+
4
14
19
b). How much is the frequency for students living over 1 mile away from the campus?
c). As to the category of Amount Spent, £, what is the modal group?
d). Assuming Mike is saving the same amount per month in the next 3 years. How much does Mike get for his saving…
arrow_forward
Q: How the net profit is calculated for product explain and derive formula for it?
arrow_forward
Question 5:
A Mechanical Design Company produces an innovative design of Batttery used for electric cars. The standard design of producing one(1) unit of Battery is provided in the bill of materials
BOM which requires material mix shown in Table Q5a. The current monthly production of Battery is 2000 units per month with the actual material consumption shown in Table Q5b.
Determine the following and justify why it is favorable or adverse.
(i) Material usage variance;
(ii) Material price variance;
(ii) Total material cost variance;
Table Q5a
Usage (units)
5
Materials
Total cost (OMR)
V
17
W
3
38
X
8
50
Y
38
Table Q5b
Usage (units)
12,047
6,902
17,556
4,122
Total cost (OMR)
50,526
94,083
103,953
76,408
Materials
V
W
Y
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- Problem 1 Dr. Song will go to McDonald's for dinner tonight. After studying operations research, he feels that he should at least be "smart" enough to figure out the way he eats it. Let's build a model to determine what to eat at McDonald's. QP AD BM FF MC FR SM 1M OJ Required Cost 3.79 4.49 3.99 3.79 1.29 1.79 1.19 1.00 1.89 Prot 28 24 25 14 31 3 15 1 55 VitA 15 15 6 8 4 10 2 100 VitC 10 2 15 15 4 120 100 Calc 30 20 25 15 15 20 30 2 100 Iron 20 20 20 10 8 15 100 Cals 510 370 500 370 400 220 345 110 80 2000 Carb 34 33 42 38 42 26 27 12 20 350 The tables gives the menu (Quarter Pounder, Angus Deluxe, etc.) along with their unit cost (in $) and amount of nutrients contained (Protain, Vitamin A, etc.) The last column of the table gives the daily required amount of nutrients suggested by Dr. Song's doctor. Suppose Dr. Song aims to minimize the cost of his dinner, while he wants to satisfy all the nutrient requirements. Formulate this problem as a linear programming model, and solve it in…arrow_forwardQuestion 3&4 This is just for knowledge purposesarrow_forwardGiven information below profit in $ pumps labor hours feet of tubing Aqua-Spa (x1) Hydro-Lux (x2) 1 2 MAX S.T. 350 1 9 12 300 1 6 16 x₁ = # of Aqua-Spa hot tubs to produce x₂ = # of Hydro-Lux hot tubs to produce 350x1 + 300x2 x1 + x₂ ≤ 200 9x1+6x2 ≤ 1566 12x₁ +16x2 ≤2880 *120 X220 total 950 3 21 44 RHS 200 1566 2880 (total profit in $) (pumps) (labor hours) (feet of tubing) Q5.1. How many resources were used to produce the optimal solution?arrow_forward
- Required information Skip to question George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week Units Total Etching Cost 1 9 $ 21 2 12 25 3 13 30 4 9 20 5 11 25 6 18 34 72 $ 155 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y = a + bX.arrow_forwardMc Graw Hill Home Page - JagApp Week 12 - Midterm #2 (100 points) i 17 Consider the following list of accounts: • Cash • Prepaid Expense • Service Revenue 8 points 01:16:23 • Salaries Expense • Accounts Payable Equipment • Retained Earnings • Common Stock • Dividends Х סוי M Question 17 - Week 12 - Midterm #2 (100 points) - Connect How many of these accounts have a normal debit balance? Numeric Responsearrow_forwardPlease do not give solution in image formate thanku.arrow_forward
- Subject: Logistic Manangement Q#1) What are the defination of Verticle and Horizontal Integration, explain with examples of each?1.1: Definition1.2: Examplesarrow_forwardQ3 Lab2 Subject: Production and operation management Please answer ASAParrow_forwardQ1 (a) Looking at the Sensitivity table above explain briefly by answering if the demand by any of these the classes is not satisfied. (b) Write down how many bookings the hotel should accept in each rental class?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios