(CIS331 -SystmMdlngThry) Figures 15.6-15.9

(CIS331 -SystmMdlngThry) Figures 15.6-15.9 - Butson Stores...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Butson Stores Parameters Monthly sales ($000) Dec Jan Feb Mar Apr May Jun Mean 1540 1800 1500 1900 2600 2400 1900 Standard deviation 80 80 100 125 120 90 Fixed Costs and taxes 250 250 400 250 250 350 Materials costs % 80% Monthly interest rates Interest cost of loan 1.0% Interest return on cash 0.5% Initial cash in Jan ($000) 250 Min cash balance ($000) 250 Base case model Dec Jan Feb Mar Apr May Jun Actual sales ($000) 1540 1800 1500 1900 2600 2400 1900 Cash and receipts Beginning cash balance 250 250 451 250 250 250 Interest on cash balance 1.3 1.3 2.3 1.3 1.3 1.3 Receipts 1540 1800 1500 1900 2600 2400 Costs Fixed costs and taxes 250 250 400 250 250 350 Materials costs 1440 1200 1520 2080 1920 1520 Loan payback (principal) 149 0 217 648 223 Loan payback (interest) 1 0 2 6 2 Cash balance before loan 101 451 33 -398 27 556 Loan amount 149 0 217 648 223 0 Final cash balance 250 451 250 250 250 556 Outputs Maximum loan 648 Loan interest 12 December sales figure is  assumed known. Demand for January through  June is assumed to equal  mean demand in the same  month.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DATA TABLE PARAMETER INFO Parameter -10 Pct +10 Pct Range Base Case Result Base Case % Sensitivity -% +% Mean sales Apr 439.65 855.65 416.00 647.65 2600.00 10.00 2340.00 2860.00 Mean sales Dec 805.53 489.80 315.74 647.65 1540.00 10.00 1386.00 1694.00 Fixed costs and taxes Mar 607.25 688.05 80.80 647.65 400.00 10.00 360.00 440.00 Mean sales Mar 684.13 611.17 72.96 647.65 1900.00 10.00 1710.00 2090.00 Mean sales Jan 682.73 612.57 70.16 647.65 1800.00 10.00 1620.00 1980.00 Mean sales Feb 677.34 617.96 59.39 647.65 1500.00 10.00 1350.00 1650.00 Fixed costs and taxes Jan 622.02 673.28 51.26 647.65 250.00 10.00 225.00 275.00 Fixed costs and taxes Feb 622.27 673.03 50.75 647.65 250.00 10.00 225.00 275.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

(CIS331 -SystmMdlngThry) Figures 15.6-15.9 - Butson Stores...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online