(Solved): 10 pertinent data -Setup labor cost is $40 per hour -It costs MBC $1.26 per year to own a gallon of ...
10 pertinent data -Setup labor cost is
$40per hour -It costs MBC
$1.26per year to own a gallon of Dinner -Dinner has an annual demand of 96,000 gallons -MBC can produce 600 gallons of beer per day -MBC works 265 days per year -Desired lot size is 1,500 gallons per production run In cell C30, input the annual demand of Dinner beer. Note this is just a typed number In cell C 31 , input the number of working days that Maine Beer Company (MBC) works per year. Note this is just a typed number In cell C32, input the number of gallons of beer MBC can make in a day. Note this is just a typed number In cell
C33, input the holding cost per unit per year for Dinner. Note this is just a typed number In cell C34, input the desired lot zie for a production run of Dinner. Note this is just a typed number In cell
C35, input the setup labor cost for MBC. Note this is just a typed number In cell C36, calculate the daily demand. -Note: This must be a formula. You must ONLY use cell references. -Do not round this numberl Keep it as the decimal. In cell F30, calculate the setup cost that would be needed in order to have the desired lot size. Nato. This muct he a fomulz and uce call roforencoc \table[[Annual Demand (D)],[Working Days],[Daily Production (p)]] \table[[Setup Cost per setup,],[Setup Time (min),]]
