Allied Freight supplies goods to three customers, who each require 30 units. The company has two warehouses. In warehouse one 40 units are available and in warehouse two 30 units are available. The costs of shipping one unit from each warehouse to each customer are listed in the accompanying spreadsheet file. There is a penalty for each unsatisfied customer unit of demand: with customer 1, a penalty cost of $90 is incurred; with customer 2, $80; and with customer 3, $110. Determine how to minimize the total cost. Solve the problem in Excel and report the optimal objective value here. Save your work and upload it along with other worksheets in a single file. (No need to report the mathematical model and optimal values of the decision variables).

You are the manager of the packaging department in a cookie factory. (obviously, the packaging employees cannot eat the cookies that are transferred in during the period.) after your employees insert cookies into colorful packages (step 1) for display on store shelves, the packages of cookies are then boxed using cardboard cartons (step 2) for shipment to stores. each unit of product is represented by a carton of packaged cookies. the packaging department began the period with 1,000 units of cookies. during the period, 5,000 units of cookies were transferred in from the baking department and 5,500 units of cookies were transferred out to the finished goods department. the number of units of cookies in the ending inventory of the packaging department equals:

Myflvs -question 3 multiple choice worth 2 points)(10.04 hc)in panama city in january, high tide was at midnight. the water level at high tide was 9 feet and1 foot at low tide. assuming the next high tide is exactly 12 hours later and that the height of thewater can be modeled by a cosine curve, find an equation for water level in january for panamacity as a function of time (t).of(t) = 4 + 5of(t) = 5 cost + 4o 460) = 5 cos 1+ 4of(0) = 4 cos + 5

Horace society is planning its annual western fair raceway gala. the gala committee has assembled the following expected costs for the event: dinner (per person) $10 gaming token and program (per person) $2 prize payouts $4,300 tickets and advertising $800 private box suite rental $1,700 lottery licenses $200 the committee members would like to charge $40 per person for the evening’s activities. required: 1. what is the break-even point for the dinner-dance (in terms of the number of persons who must attend)? 2. assume that last year only 200 persons attended the dinner-dance. if the same number attend this year, what price per ticket must be charged in order to break even? 3. refer to the original data ($40 ticket price per person). prepare a cvp graph for the dinner- dance from zero tickets up to 600 tickets sold.