Ops midterm solutions

Ops midterm solutions - 895.7 Sep 961.5 2,400.0 0.0 576.9...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Jan $1.90 2.1 700 1,200 Feb $1.85 2.1 1,000 1,500 Mar $1.75 2.3 1,100 2,000 Apr $1.65 2.4 1,200 2,000 May $0.95 2.5 1,100 1,500 Jun $0.85 2.2 700 1,200 Jul $0.85 2.2 800 1,700 Aug $0.85 2.2 900 1,600 Sep $0.90 2.4 1,900 2,400 Oct $1.35 2.5 2,000 2,700 Nov $1.45 2.2 2,000 2,800 Dec $1.80 2.1 2,400 3,000 Cheese Price $4.15 per pound Processing Cost $4.85 per gallon Max Milk Processed 1,200.0 gallons per month Min Milk Buy per Month 5.0% Max Milk Buy Change per Month 25.0% Inventory Cost $0.85 per pound per month Prior December's Milk Purchase 400.0 gallons Starting Cheese Inventory 80.0 pounds Prior Dec 400.0 80.0 Jan 500.0 1,130.0 0.0 300.0 500.0 Feb 625.0 1,312.5 0.0 375.0 625.0 Mar 781.2 1,796.9 0.0 468.7 781.2 Apr 833.3 2,000.0 0.0 585.9 976.6 May 625.0 1,500.0 62.5 625.0 1,041.7 Jun 573.2 1,200.0 123.6 468.8 781.3 Jul 716.5 1,700.0 0.0 429.9 716.5 Aug 769.2 1,600.0 92.3 537.4
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 895.7 Sep 961.5 2,400.0 0.0 576.9 961.5 Oct 1,144.0 2,700.0 160.0 721.2 1,201.9 Nov 1,200.0 2,800.0 0.0 858.0 1,430.0 Dec 1,200.0 2,520.0-0.0 900.0 1,500.0 Total 9,929.1 22,659.4 Min Monthly Buy (Annual Rule) 496.5 gallons of milk Revenue $94,036.41 Milk Cost $13,502.13 Processing Cost $48,156.26 Inventory Cost $372.66 Profit $32,005.37 Milk Cost per Gallon Yield (Pounds Cheese per Gallon of Milk) Minimum Pounds Cheese to Sell Maximum Cheese to Sell Gallons Milk Bought Pounds Cheese Sold Pounds Cheese In Inventory Min Buy (Change Rule) Max Buy (Change Rule) A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46...
View Full Document

Ask a homework question - tutors are online