Question: please give formula and there this not same question with coffee and cake Question1 (40 marks) PT 10 STL --> AT 11 STL --> PX

please give formula and there this not same

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

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

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

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

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

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

only need to answer the questions C25 to C76, thank you so much. Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "?" in column C such that formula could be...

By December 31, 2013, Clearing Corp. had performed a significant amount of environmental consulting services for Rank Ltd. Rank was short of cash, and Clearing agreed to accept a $200,000, non-...

The most recent financial statements for Burnaby Co. are shown here: Statement of Comprehensive Income $16,400 12,430 $ 3,970 1,588 $ 2,382 Statenent of Financial Position $11,200 27,800 $38, 200...

Now read another extract from The Teardrop Island. Here, the narrator describes a character called Glen. As you read, make notes on: how the writer presents Glen's movements in the first paragraph ...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...