OGL make four (4) products. Some of the cost data about the products from the previousyear is shown in the table below:SM-567 LG-321 JK-123 GJ-444Current Sales Price $80.00 $90.00 $100.00 $150.00Sales Revenue $300,000 $720,000 $530,000 $450,000Variable Expenses $204,000 $446,400 $318,000 $261,000Total fixed expenses amount to $600,000.Required1. Prepare a spreadsheet to determine the break even point in sales dollars for theseproducts using the above information, based on a sales mix using sales dollars as thebasis. 2. Create a new sheet/tab in the spreadsheet that determines the sales dollars required tomake a profit of $250,000. This should also be based on a sales mix using sales dollarsas the basis. 3. Create a new sheet/tab in the spreadsheet that calculates the break even point in unitsand sales dollars, based on the sales mix below, using units sold as the basis. For thepurposes of this part of the question assume thatthe sales mix percentage based on units is shown in the table below.
The post AMMA600 Financial And Management Accounting appeared first on My Assignment Online.