please answer the accounting question

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 Material 0.50 0.15 additional amounts that must be paid Indirect Labour 1.50 1.10 a decrease in amounts that must be paid Utilities 0.25 0.25 additional revenue that will be earned Unit Variable Costs 12 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 1,700 2,600 Utilities 7,500 4.590 Make-or-Bux Rent 0,000 150,000 Neptune Berhad has approached Mr Roy with a proposal to purchase ready-to-sell Dreamer at Depreciation - Equipment 63,000 87.000 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 1 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 20247 Why or why not? DREAMER Desired Finding Raw Material Inventory one-tenth (1/10) of the following period's required materials Beginning Raw Material 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%% 10% Freight Expenses 20% 20% 2. The following data were provided to the Finance Manager: per semi-annually $ per semi-annually Data Source I: Saks Manager Sales Salaries 105,000 210,000 Insurance 10,00 15,000 COASTAL Unity* Unit Selling Price Comments Advertising 10,00 0 Q4, 2023 - expected 10,000 $ 630.00 actual sales data not available 25,000 Depreciation - Caravel 30,000 9.000 Q1 - Q2, 2024 630.00 73,000 Q3 - Q4, 2024 25,000 General Administration Salaries $ 630.00 75,000 Q1, 2025 expected incream in Producer Total Fixed Expenses $285,000 $309,000 30,000 $ 650.00 Price Index (PPD) I box = 10 watts DREAMER Unite" 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.00 Q3 - Q4, 2024 36.000 $ 200.00 expected decrease in demand COASTAL DREAMER Q1. 2025 40,000 $ 230.00 expected increase in Producer Cash, 1/1/2024 (expected) $100,750 $105.220 Price Index (PPI) Interest Rate on Borrowings for 2024 5.00% per annum 5.00% per annum . T box = 10 watts due 2025 due 2025 Proposed Unit Selling Price for DREAMER in Q3-Q4, 2024 to meet the sales target of Loans", h/f - from 2021 $ 500,00 40,000units: $ 150.00 per unit. at 5.00% p.u. interest Data Source 2: Production Manager *All repayments are expected to be settled with cash in the earliest period possible in 2024 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. Beginning Finished Goods Inventory 2,500 units for the years 2024 and 2025 10% are expected to be uncollectible 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 labour # proward by /IN Manager