Question: Question1 (40 marks) PT 10 STL --> AT 11 STL --> PX 12 BSN --> PT 13 BSN --> AT 14 BSN --> PX 15

Question1 (40 marks) < Refer to Table 1. Write

Question1 (40 marks) PT 10 STL --> AT 11 STL --> PX 12 BSN --> PT 13 BSN --> AT 14 BSN --> PX 15 TAX RATE EXPECTED 16 MIN CASH RQRD AT END OF YR 17 FIXED ADMINISTRATIVE COSTS 20 INPUTS EXPECTED STATE OF ECONOMY: 21 F = FLAT, H = HOT WAREHOUSE LOCATION NOT USED: PT = PORTLAND; 22 AT = ATLANTA; PX = PHOENIX -- B 2021 2022 500000 750000 500000 750000 4.5 5.5 3.5 6 4.5 5.5 0.29 10000 1200000 2022 H PT 2021 D 2023 750000 850000 750000 850000 4.95 6.05 3.85 6.6 4.95 6.05 0.3 10000 1200000 2023 F E 2024 1000000 1000000 1000000 1000000 5.45 6.66 4.24 7.26 5.45 6.66 0.31 10000 1200000 2024 F A LU 24 CALCULATIONS 25 INTEREST RATE FOR YEAR 26 NUMBER OF DOLLS SHIPPED 27 FROM STL TO PT 28 FROM STL TO AT 29 FROM STL TO PX 30 FROM BSN TO PT 31 FROM BSN TO AT 32 FROM BSN TO PX 33 SHIPPING & WAREHOUSING COSTS 34 FROM STL TO PT 35 FROM STL TO AT 36 FROM STL TO PX 37 FROM BSN TO PT 38 FROM BSN TO AT 39 FROM BSN TO PX 40 UNIT SELLING PRICE - Micky 41 UNIT SELLING PRICE - Mimi 42 SALES REVENUE - Micky 43 SALES REVENUE - Mimi 44 UNIT PRODUCTION & MARKETING COSTS: 45 ST LOUIS (BOTH DOLLS) 5 46 BSN (BOTH DOLLS) 5.5 47 TOTAL PRODUCTION & MARKETING COSTS 48 ST LOUIS (BOTH DOLLS) 49 BOSTON (BOTH DOLLS) B 2021 2022 NA NA NA NA NA NA NA NA NA NA NA NA NA 11.25 12.25 NA NA ? [1.5 marks] ? [1.5 marks] ? [1.5 marks] ? [1.5 marks] ? [1.5 marks] ? [1.5 marks] ? [1.5 marks] ? [1 mark] ? [1 mark] ? [1 mark] ? [1 mark] ? [1 mark] ? [1 mark] ? [1.5 marks] ? [1.5 marks] ? [1 mark] ? [1 mark] ? [1.5 marks] ? [1.5 marks] ? [1 mark] ? [1 mark] NA NA D 2023 copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste E 2024 copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste A INCOME STATEMENT AND 52 CASH FLOW STATEMENT 53 BEGINNING OF YEAR CASH ON HAND 55 REVENUE (SALES) 56 COSTS AND EXPENSES: 57 PRODUCTION AND MARKETING COSTS SHIPPING AND WAREHOUSE COSTS 59 FIXED ADMIN COSTS 58 60 TOTAL COSTS 61 PRE-INTEREST EXPENSE MARGIN 62 INTEREST EXPENSE 63 INCOME BEFORE TAX 64 TAX EXPENSE 65 NET INCOME 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 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 YEAR 3000000 B 2021 NA NA 10000 2022 ? [0.25 mark] ? [0.5 mark] ? [0.5 mark] ? [0.5 mark] ? [0.25 mark] ? [0.5 mark] ? [0.5 mark] ? [1 mark] ? [0.25 mark] ? [1 mark] ? [0.5 mark] ? [0.5 mark] ? [1.5 marks] ? [4 marks] ? [0.5 mark] ? [0.25 mark] ? [0.25 mark] ? [0.25 mark] ? [0.5 mark] D 2023 copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste E 2024 copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste copy & paste

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

HISARNA - DEVELOPING A SUSTAINABLE STEEL PRODUCTION PROCESS ABSTRACT The steel industry in Europe was looking for a way to increase the efficiency of steel production, and redesign the production...

24 ]25 26 27 28 29 30 ]32 ]34 ]36 31 33 35 37 38] ]39 40 41 42 | 43 44 45 46 47 J |481 [50 49 51 2022 J 1.5 marks 1.5 marks 1.5 marks 1.5 marks 1.5 marks 1.5 marks 1.5 marks 1 mark 1 mark 1 mark 1...

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...

please give formula and there this not same question with coffee and cake Question1 (40 marks) PT 10 STL --> AT 11 STL --> PX 12 BSN --> PT 13 BSN --> AT 14 BSN --> PX 15 TAX RATE EXPECTED 16 MIN...

New Age Dolls makes the very successful line of Micky and Mimi dolls, which rapidly gained popularity with children and teenagers after only a few years on the market. New Age Dolls produces dolls at...

please provide answers as excel formula's after reading the questions! thank you Refer to Table 1. Write the Excel formula for each cell marked with ?" in column C such that formula could be copied...

can you please answer this question Beginning of year cash on hand (row 53): this is the cash at the end of the previous year. Revenue sales (row 55): this is the total revenue from sales of all the...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "?" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with ? in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

Derive the sensitivity equation for the Van der Pol oscillator as varies from its nominal value. Use the state equation in the x coordinates. 3

What is the firm cost of capital ? What is the firm pre-tax cost of debt? 1. Your firm has $280 million in equity and $340 million in debt. The shares which are priced at $59.73 just year paid a...

A company purchases merchandise for $ 6 0 0 plus a freight charge of $ 6 0 from a supplier, payment is due in 3 0 days. The $ 6 0 freight charge will be recorded as a ( debit / credit ) to the in...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...