Please complete the Excel. Thank You!

A 1 Micky AND Mimi WAREHOUSING DECISION 2 3 CONSTANTS 2016 Micky PRODUCTION - STL 5 Mimi PRODUCTION - STL 6 Micky PRODUCTION - BSN Mimi PRODUCTION - BSN PER UNIT SHIPPING AND 8 WAREHOUSING COSTS (FROM-TO) 9 STL-> PTLD 10 STL -> ATL 11 STL -> PHX 12 BSNPTLD 13 BSN-> ATL 14 BSN-> PHX 15 TAX RATE EXPECTED 16 MIN CASH RORD AT START OF YR 17 FIXED ADMINISTRATIVE COSTS 18 19 20 INPUTS EXPECTED STATE OF ECONOMY: 21 F= FLAT, H = HOT WAREHOUSE LOCATION NOT USED: PT PORTLAND, 22 ATATLANTA; PX = PHOENIX 23 24 CALCULATIONS 25 INTEREST RATE FOR YEAR 26 NUMBER OF DOLLS SHIPPED 27 FROM STL TO PTLD 28 FROM STL TO ATL 29 FROM STL TO PHX 30 FROM BSN TO PTLD 31 FROM BSN TO ATL FROM BSN TO PHX 32 B 2017 NA 500000 NA 750000 NA 500000 NA 750000 NA 4.5 NA 5.5 3.5 6 4.5 5.5 0.29 10000 NA 1200000 #33333333 2016 2017 NA NA 2016 2017 NA 3333333 NA NA NA NA NA H PT 2018 750000 850000 750000 850000 4.95 6.05 3.85 6.6 4.95 6.05 0.3 10000 1200000 2018 2018 D F NA 2019 1000000 1000000 1000000 1000000 5.45 6.66 4.24 7.26 5.45 6.66 0.31 10000 1200000 2019 2019 E F NA B NA NA NA NA NA NA 11.25 12.25 A 32 JZ FROM BSN. TO PHA 33 SHIPPING & WAREHOUSING COSTS 34 FROM STL TO PTLD 35 FROM STL TO ATL 36 FROM STL TO PHX 37 FROM BSN TO PTLD 38 FROM BSN TO ATL 39 FROM BSN TO PHX 40 UNIT SELLING PRICE -Micky 41 UNIT SELLING PRICE - Mimi 42 DOLLARS OF SALES (REVENUES) - Micky 43 DOLLARS OF SALES (REVENUES) - Mimi 44 UNIT PRODUCTION & MARKETING COSTS: 45 ST LOUIS (BOTH DOLLS) 5 5.5 46 BSN (BOTH DOLLS) 47 TOTAL PRODUCTION & MARKETING COST: 48 ST LOUIS (BOTH DOLLS) 49 BOSTON (BOTH DOLLS) 50 51 INCOME STATEMENT AND 52 CASH FLOW STATEMENT 53 BEGINNING OF YEAR CASH ON HAND 54 55 REVENUE (SALES) 56 COSTS AND EXPENSES: 57 PRODUCTION AND MARKETING COSTS 58 SHIPPING AND WAREHOUSE COSTS 59 FIXED ADMIN COSTS 60 TOTAL COSTS 61 PRE-INTEREST EXPENSE MARGIN 62 INTEREST EXPENSE 63 INCOME BEFORE TAX 64 TAX EXPENSE 65 NET INCOME 66 NA NA NA NA 2016 NA NA NA NA NA NA NA NA NA NA NA 2017 2018 D 2019 E B INA 10000 2016 A OU NET INCOIVIC 66 NET CASH POSITION (NCP) BEFORE BORROWINGS AND REPAYMENTS OF 67 DEBT (BEG CASH PLUS NET INCOME) 68 ADD: BORROWINGS FROM BANK 69 LESS: REPAYMENTS TO BANK 70 EQUALS: END OF YEAR CASH ON HAND 71 72 DEBT OWED 73 OWED TO BANK AT BEGINNING OF YEAR 74 ADD: BORROWINGS FROM BANK 75 LESS: REPAYMENTS TO BANK 76 EQUALS: OWED TO BANK AT END OF YEA 3000000 2017 C 2018 D 2019 E