Please answer the question 1) & 2) with calculation

Question This question may require additional information from the Data Source provided to the FinanceManager to complete the requirements. COST CARD: - Manufacturing Overhead "Relevant costs can be defined as any cost relevant to a decision. A matter is relevant if there COASTAL DREAMER is a change in cash flow that is caused by the decision. The change in cash flow can be: $ per DLH S per DLH Indirect Materia 0.50 0.15 additional amounts that must be paid Indirect Labour 1.10 a decrease in amounts that must be paid Utilities 0.25 0.25 additional revenue that will be earned Unit Variable Costs $2.25 $1.50 a decrease in revenue that will be earned. $ per semi-annually $ per semi-annually A change in the cash flow can be identified by asking if the amounts that would appear on the Maintenance 15,300 30,810 company's bank statement are affected by the decision, whether increased or decreased." Insurance 11,700 2,600 Utiliti 7,500 4,590 Make-or-Bux Rent 20,000 50,000 Neptune Berhad has approached Mr Roy with a proposal to purchase ready-to-sell Dreamer at Depreciation - Equipment 63,900 87,900 a price of $ 150.00 per unit for 2024. Both the fixed manufacturing overhead ($285,00 persemi- Total Fixed Costs $187,500 $285,000 annual), and, fixed selling and administrative expenses ($309,000 per semi-annual) areallocated cost. The costs will be incurred irrespective of whether the Dreamer are produced orpurchased. Data Source 3: Sales Manager Required: COASTAL DREAMER 1) Based on the characteristics of relevant costs, are the fixed manufacturing Direct Material Cost $50 per seashell $2.50 per seashell overhead, and, fixed selling and administrative expenses relevant costs? Justify your 1 Production Unit I seashell per unit 4 seashell per unit decision. COASTAL Desired Ending Raw Material Inventory one-tenth (1/10) 2) Prepare an incremental analysis for the decision to make-or-buy the Dreamer in of the following period's required materials 024. Beginning Raw Material Inventory 2,500 seashells for the years 2024 and 2025 3) Should NBNB make or buy the Dreamer from Neptune Berhad in 2024? Why or why not? DREAMER Desired Ending Raw Material Inventory one-tenth (1/10) of the following period's required materials Beginning Raw Material Inventory 15,840 seashells for the years 2024 and 2025 COST CARD: - Selling & Administrative Expenses COASTAL DREAMER Variable Rate on Expected Sales Revenue Sales Commission 15% 15% Travel and Transportation 30% 30% Freight Expenses 20% 20% 2. The following data were provided to the Finance Manager per semi-annually $ per semi-annually Data Source I: Sakes Manager Sales Salaries 105,000 210,000 Insurance 50,00 15,000 COASTAL Units* Unit Selling Price Comments Advertising 90,000 Q4, 2023 - expected 10,000 $ 630.00 actual sales data not available Depreciation - Carave 30,000 9.000 Q1 - Q2, 2024 25,000 $ 630.00 Q3 - Q4, 2024 25,000 $ 630.00 General Administration Salaries 75,000 75,000 Q1, 2025 Total Fixed Expenses $285,000 $309,000 30,900 $ 650.90 expected increase in Producer Price Index (PPD) I box = 10 weir DREAMER Units" Unit Selling Price Comments 3. The Cost Accountant extracted the following information from NHNH's database: Q4, 2023 - expected 20,900 $ 200.00 actual sales data not available Q1 - Q2. 2024 40,000 $ 200.0 Q3 - Q4, 202 36,000 $ 200.00 expected decrease in demand COASTAL DREAMER Q1. 2025 expected increase in Producer Cash, 1/1/2024 (expected) $100,750 40,000 $105,220 $ 230.00 Price Index (PPI) Interest Rate on Borrowings for 2024 5.00% per annum 5.00% per annum Thax = 10 watts due 2025 due 2025 Proposed Unit Selling Price for DREAMER in Q3-Q4, 2024 to meet the sales target of Loans", hof - from 2021 $ 500,000 40,000units: $ 150.00 per unit. at 5.00% p.m. interest *All repayments are expected to be setied with cash in the earliest period possible in 2024 Data Source 2: Production Manager COASTAL Cash Collection Terms Desired Ending Finished Goods Inventory 10.009% All sales are expected to be collected in cash at of the following period's required sales unit 60% in the current period and the remaining 30% in the immediate next period. Begin ing Finished Goods Inventory 2.500 units 10% are expected to be uncollectible. for the years 2024 and 2025 Cash Payment Terms DREAMER Suppliers are paid in cash in two separate payment period: Desired Ending Finished Goods Inventory 10.00% Half in the current period of purchase and the remaining in the next period. of the following period's required sales unit Beginning Finished Goods Inventory 4,000 units COASTAL DREAMER for the years 2024 and 2025 Accounts Receivable, 1/1/2024 $1,890,000 $1,200,000 COASTAL DREAMER Accounts Payable, 1/1/2024 $ 326,250 $ 112,320 Direct Labour Cost $ 5.00 per direct labour $ 4.00 per direct labor as proward by file Manager hours (DLI) 1 Production Unit 30 required DLH 25 required DL.H