Update and Approve

Keystone Air Solutions, Inc., manufactures air conditioning units. The company has three variants: Window ACs, Spilt ACs, and Inverter Split ACs. Keystone has two types of customers. Customer type 1 purchases mostly Window ACs. Customer type 2 purchases all three product variants and is also the only customer type that purchases Inverter ACs. Data regarding the product mix for each customer follows: Data regarding the product mix for each customer follows: (Click the icon to view the customer data.) A schedule showing the gross profit for each product line follows: (Click the icon to view the schedule.) Requirement 1. Prepare a schedule that calculates the gross profit available to cover other value-chain costs for each customer type. Requirement 1. Prepare a schedule that calculates the gross profit available to cover other value-chain costs for each customer type. (For amounts with a 0 balance, make sure to enter "0" in the appropriate cell. Round the gross profit per unit to four decimal places and gross profit calculations to the nearest whole euro.) Customer type 2 Customer type 1 Gross profit per unit Units sold Gross profit Units sold Gross profit Data table Window AC Split AC Inverter Split AC Total Window AC Split AC Inverter Split AC Cost per Activity/Resource driver unit Setup/Maintenance 2,582.67 Assembly 262.70 Driver units 54 1,000 Cost Driver units Cost Driver units Cost 139,464 262,700 20 1,200 Data table Parts 37,859,086 11,620,000 51,653 315,240 6,064,672 1,530,000 16 600 41,323 157,620 743,842 260,000 Direct labor Units Sold Across Product Variants Total 49,881,250 7,961,565 1,202,785 Window AC Split AC Inverter Split AC Total Units 230,000 23,000 2,300 Customer type 1 176,000 11,500 Customer type 2 54,000 11,500 0 187,500 2,300 Cost per display 216.875 346.155 522.95 67,800 330.00 510.00 765.00 Selling price 230,000 23,000 2,300 255,300 Total 113.125 163.845 242.05 Unit gross profit 26,018,750 3,768,435 556,715 Total gross profit Print Done BLACKBOX AI