GreenTech specialises in manufacturing and selling high-quality, sustainable Smart Televisions. These televisions offer advanced features such as 4K resolution, smart connectivity, voice control, and streaming services integration. GreenTech aims to capture a significant share of the global Smart TV market. The following data relates to GreenTech's best selling Sustainable Smart TV Model SMTV007.

Metric

Units Produced and Sold (SMTV007) Selling Price per Unit (SMTV007) Direct Materials (kilos) Direct Materials Cost per kilo Manufacturing Capacity (units) Conversion Costs

Conversion Costs per Unit of Capacity Selling and Customer-Service Capacity (customers) Total Selling and Customer-Service Costs Selling and Customer-Service Cost per Customer

2022 2023

5,000 5,500 $400 $440 15,000 15,375 $40 $44 10,000 10,000 $1,000,000 $1,100,000 $100 $110 60 58 $360,000 $362,500 $6,000 $6,250

GreenTech Corporation produces no defective units but it wants to reduce direct materials usage per unit of SMTV007 in 2023. Manufacturing conversion costs in each year depend on production capacity defined in terms of SMTV007 units that can be produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. GreenTech Corporation has 46 customers in 2022 and 50 customers in 2023. The industry market size for Sustainable Smart Screens increased 5% from 2022 to 2023.

REQUIRED

Give me the answer in EXCEL spreadsheet to make the following calculations for GreenTech Corporation's management.

Operating profit for 2022 and 2023

Growth component of change in operating profit

Price-recovery component of change in operating profit

Productivity component of change in operating profit

Reconciliation of change in operating profit