Consider the following sensitivity report generated by Excel Solver for Beaver Creek Pottery Company
Consider the following sensitivity report generated by Excel Solver for Beaver Creek Pottery Company
i What is the optimal production plan for the pottery company? What is their expected total revenue by adopting the production plan?
ii. What is the range of optimality for units of mugs to be produced by the pottery company?
iii. What is the range of feasibility for clay for the pottery company?
iv.Is there excess unit of clay for the proposed production plan? Why?
v. What is the maximum rate payable for every additional hour of labour?
Homework Answers
Add Answer to:
Consider the following sensitivity report generated by Excel Solver for Beaver Creek Pottery Company
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and...
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and...
Create a spreadsheet in excel and develop a sensitivity and answer report. Use the sensitivity and answer report to answer the questions below. Do not reuse solver. Please show your work and where you get the information: Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce up to 700 bikes and wants to ensure the number of Razors produced does not exceed...
The following data for a pottery company pertain to the production of 2,000 clay pots during...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used): Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the total direct materials...
The following data for a pottery company pertain to the production of 2,000 clay pots during...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used) Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the direct manufacturing labour...
The following data for a pottery company pertain to the production of 2,000 clay pots during...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used): Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the standard direct material...
The following data for a pottery company pertain to the production of 2,000 clay pots during...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used): Standard cost: $2.00 per kilogram of clay Total actual cost: $10,640 Standard cost allowed for units produced was $12,000 Materials quantity variance was $800 favourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 1028 hours show all steps! a. What is...
JUST NEED HELP WITH PART 2 (EXCEL SOLVER) Clearlake Marketing Group (CMG) is a full-service marke...
JUST NEED HELP WITH PART 2 (EXCEL SOLVER) Clearlake Marketing Group (CMG) is a full-service marketing research company. CMG is being hired to interview registered voters in a city to gain insights into their opinions about certain political issues. Each voter is to be interviewed in person. The costs of interviewing different types of voters vary due to the differences in proportion throughout the population. Based on previous studies, estimates of the interview costs for different types of voters are...
MY QUESTION IS : Prepare a short technical report on the above problem. PLEASE HELP i....
MY QUESTION IS :
Prepare a short technical report on the above problem.
PLEASE HELP
i. What is the impact on profit of a change in the supply of nonelectronic components? ii. What is the impact on profit if we could increase the supply of electronic components by 400 units (to a total of 5,100)? iii. In the previous question what would happen, if we could increase the supply of electronic components by 4,000 units (to a total of 8,700...
Case studies are used to enable you to apply new concepts, use the tools you have...
Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve the technical skills you have attained. Through the individual case studies you will discover for yourself the usefulness of quantitative problem solving methods, how to apply them in practice, and their benefit to organizational decision-makers. In this case study, you will act as a consultant for a manufacturing company looking to maximize net profit generated by a production facility subject to...
NanuqCatering is planning to produce 'ready-to-go' tray of sandwiches. Each tray will include tuna, tuna/cucumber, ham,...
NanuqCatering is planning to produce 'ready-to-go' tray of sandwiches. Each tray will include tuna, tuna/cucumber, ham, ham/cucumber, and cucumber sandwiches. Most popular orders come in the range of 80 to 160 sandwiches per tray. The management has specified a minimum of 15 each of tuna and ham, 12 each of tuna/cucumber and ham/cucumber and 15 cucumber sandwiches to be included in each tray. Due to demand the management also specified that the company should make fewer ham sandwiches than cucumber...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used): Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the total direct materials...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used) Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the direct manufacturing labour...
The following data for a pottery company pertain to the production of 2,000 clay pots during July. Direct Materials (all materials purchased were used): Standard cost: $6.00 per kilogram of clay Total actual cost: $11,200 Standard cost allowed for units produced was $12,000 Materials efficiency variance was $240 unfavourable Direct Manufacturing Labour: Standard cost is 2 pots per hour at $24.00 per hour Actual cost per hour was $24.50 Actual labour was 972 hours What is the standard direct material...
MY QUESTION IS :
Prepare a short technical report on the above problem.
PLEASE HELP
i. What is the impact on profit of a change in the supply of nonelectronic components? ii. What is the impact on profit if we could increase the supply of electronic components by 400 units (to a total of 5,100)? iii. In the previous question what would happen, if we could increase the supply of electronic components by 4,000 units (to a total of 8,700...
NanuqCatering is planning to produce 'ready-to-go' tray of sandwiches. Each tray will include tuna, tuna/cucumber, ham, ham/cucumber, and cucumber sandwiches. Most popular orders come in the range of 80 to 160 sandwiches per tray. The management has specified a minimum of 15 each of tuna and ham, 12 each of tuna/cucumber and ham/cucumber and 15 cucumber sandwiches to be included in each tray. Due to demand the management also specified that the company should make fewer ham sandwiches than cucumber...
Most questions answered within 3 hours.
-
On October 1, 20X1, a company purchased a piece of land by
agreeing to pay the...
asked 6 minutes ago -
Jamie is doing a survey at her school about whether the students
feel the cafeteria food...
asked 11 minutes ago -
What are the roles of 3' and 5' untranslated regions in
mRNAs?
asked 13 minutes ago -
A domestic television receives antenna delivers a sky noise
power of -105 dBm to a matched...
asked 11 minutes ago -
What do you think are the chemical reactions involved in the
breathalyzer tests administered to potentially...
asked 26 minutes ago -
A random sample of 120 observations produces a mean of
38.2 from a population with a...
asked 33 minutes ago -
The average area of land burned by forest fires every year in
Canada is 2.5 million...
asked 35 minutes ago -
36. The basic difference between government bureaus and market
firms is that bureaus:
a. can...
asked 35 minutes ago -
java
- A recursive method findR() to search for a number in list
(ArrayList)
- A...
asked 54 minutes ago -
Which of the following is an example of a screen against adverse
selection? [Mark All That...
asked 53 minutes ago -
A worker drives a 0.560 kg spike into a rail tie with a 2.76 kg
sledgehammer....
asked 58 minutes ago -
Assume the following information concerning two stocks that make
up an index. What is the price-weighted...
asked 1 hour ago