need calculations for this, with clear formulas thank you
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 $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." nsurance 11,700 12,600 Utilities 7,500 4,59 Make-or-Buy Real 90,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,001 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 2) Prepare an incremental analysis for the decision to make-or-buy the Dreamer in Desired Ending Raw Material Inventory one-tenth (1/10) of the following period's required materials 2024. 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 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 20124 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: Saks Manager Sales Salaries 105,00 210,000 Insurance 60,000 15,000 COASTAL Unity* nit Selling Price Comments Advertising 0,00 Q4, 2023 - expected 10,000 $ 630.00 actual sales data not available Depreciation - Caravel 30,000 Q1 - Q2, 2024 9.00 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,000 $ 650.90 expected increwur in Producer Price Index (PPD) I box = 10 weiss DREAMER Units Theit Selling Price Comments 3. The Cost Accountant extracted the following information from NBNB's database: Q4, 2023 - expected 20,000 $ 200.90 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 (PPg) Interest Rate on Borrowings for 2024 5.00% per annum 5.00% per annum I box = 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,00 40,000units: $ 150.00 per unit at 5.00% p.a. interest *All repayments are expected to be settled 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. Beginning Finished Goods Inventory 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 for the years 2024 and 2025 COASTAL DREAMER 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 provided by IINt Manager hours (DLID)