Corresponding data table to find number of loaves to bake

Assignment Help Operation Management
Reference no: EM13899204

The owners of Good Taste, a bakery in Lewisburg, PA are attempting to determine how many loaves of their famous raisin bread to bake for the first day of the upcoming county fair. Company accounting records show that each loaf of raisin bread costs \$1.30 to make. Good Taste plans to sell each loaf for \$2.75. Unsold loaves can be sold on the county fair’s second day as “day-old” products. The owners plan to sell such loaves for \$1.00 each. The bakery owners believe that the number of loaves they will sell on the county fair’s first day follows the probability distribution as provided in the file. Their goal in deciding how many loaves to bake is to maximize expected profit from these sales.

1) Develop an Excel simulation model in the attached shell.

2) Develop a corresponding data table to find the best number of loaves to bake.

Output would the two locations have the same total cost

At what volume of output would the two locations have the same total cost? For what range of output would location A be superior? For what range would B be superior?

Perform recruitment analysis

Perform a recruitment analysis to estimate the specific new talent requirements needed in the long and short term. Jobs in question: Elementary School Principal ( 10 + years o

Strategic management of technological innovation

Describe a technological innovation not discussed in chapter 9, and identify where you think it lies on the control continuum between wholly proprietary and wholly open. The b

In whose favor is the court most likely to rule

Baby-B-Mine argues that the phrase is not generally assiciated with any particular firm, pointing to other companies that use the same phrase on their labels. In whose favo

Breakeven after including the desired profit

A company is offering a 3-day short course. The following are the cost components. How much does the company need to charge per student to break even if management expects 20

Significant challenges for effectively coordinating

What is the process in your community for the activation of local, state, and federal resources? What are the most significant challenges for effectively coordinating these re

The tennis club has a number of inventories

The tennis club has a number of inventories it must manage and must minimize all its expenses to stay in business. For each inventor, describe a goo management policy or sys

Using the five forces of competition model

Use the Internet to research the industry of your choice in light of the Five Forces of Competition Model. Analyze the industry you selected using the Five Forces of Competiti