PS1 - ES
.xlsx
School
University of Washington**We aren't endorsed by this school
Course
QMETH 4
Subject
Management
Date
Jan 13, 2025
Pages
6
Uploaded by MateTarsier4243
Daytime CallEvening CallWife25%25%Husband10%25%Single Male20%15%Single Female15%20%No Answer30%15%TotalCalls Placed6754501125Cost per Call$0.85$1.00 Cost573.75$450.00 $1,023.75AnswersDaytime CallsEvening CallsTotalWife168.75112.5281.25 >=220Husband67.5112.5180 >=180Single Male13567.5202.5 >=130Single Female101.2590191.25 >=110No Answer202.567.5270Evening Calls450 <=45040% of Total Calls
JanuaryFebruaryMarchAprilMayMonthly Wage Rate$6,500$6,500$6,700$6,700$7,100Mfg. Hours Required8,8009,50011,20010,3009,700<=<=<=<=<=Mfg. Hours9690 10643.6842111120011200 11452.631579FTE Hours969011200112001120011600Time Spent on Trainees0 556.3157894700 147.36842105Fully Trained Employees51 58.947368421 58.947368421 58.947368421 61.052631579Hire at Beg of Month0 7.947368421100 2.1052631579Fire at Beg of Month00000<=<=<=<=<=7.65 8.8421052632 8.8421052632 8.8421052632 9.1578947368% of Monthly Wage RateFully Trained 100%$331,500$383,158$394,947$394,947$433,474Trainees75%$0$38,743$0$0$11,211Fired50%$0$0$0$0$0Time from FTE per Trainee70Total FTE time190Max Fired per Month15% of FTE
JuneJulyAugustSeptember$7,100$7,200$7,200$7,30011,60010,7007,9008,700<=<=<=<=1160010700 9304.347826187001160010700 9304.34782618700000061.052631579 56.315789474 48.970251716 45.78947368400000 4.7368421053 7.34553775743.180778032<=<=<=<=9.1578947368 8.4473684211 7.3455377574 6.8684210526Total$433,474$405,474$352,586$334,263$3,463,823$0$0$0$0$49,954$0$17,053$26,444$11,610$55,106$3,568,883
Tyco Cashflowper monthafter 3 monthsLT Rate0.40%ST Rate0.60%Savings Rate0.20%3-Month CD0.95%JanFebMarAprMayJunStarting Balance$2,000$18,248$8,134$0$0$0Cash Flow-$12,000-$10,000-$8,000-$10,000-$4,000$5,000LT Loan$37,644>=$0ST Loan$0$0$0$666$4,821$0>=>=>=>=>=>=$0$0$0$0$0$03-Month CD-$9,395$0$0$0$0$0<=<=<=<=<=<=$0$0$0$0$0$0LT Loan PaybackST Loan Payback$0$0$0-$666-$4,8213-Month CD Return$9,395$0$0LT Interest-$151-$151-$151-$151-$151ST Interest$0$0$0-$4-$293-Month CD Interest$89$0$0Savings Interest$36$16$0$0$0Ending Balance$18,248$8,134$0$0$0$0>=>=>=>=>=>=$0$0$0$0$0$0ABCDEFGH12345678910111213141516171819202122232425262728293031
JulAugSepOctNovDecJan$0$0$0$0$7,126-$10$50,340-$7,000-$2,000$15,000$12,000-$7,000$45,000$7,151$9,344$0$0$0$0>=>=>=>=>=>=$0$0$0$0$0$0$0$0-$5,449-$4,723$0$0<=<=<=<=<=<=$0$0$0$0$0$0-$37,644$0-$7,151-$9,344$0$0$0$0$0$0$0$0$0$5,449$4,723$0-$151-$151-$151-$151-$151-$151-$151$0-$43-$56$0$0$0$0$0$0$0$0$0$52$45$0$0$0$0$0$14$0$101$0$0$0$7,126-$10$50,340$17,415>=>=>=>=>=>=$0$0$0$0$0$0IJKLMNOP12345678910111213141516171819202122232425262728293031
$0$0Q12345678910111213141516171819202122232425262728293031