Exercise 1. Lap Tech Inc. (32 points) Table 1. Forecasted and actual data for the project Data Project Forecast (Static Budget) Project Actual Net initial investment [(] 3,000,000 3,000,000 Useful life [years 10 Terminal disposal value 0 RRR [%] 10% 10% Income tax rate [%] 30% Depreciation Straight line Straight line Table 2. Forecasted and actual operating dato Data Project Forecast Project Actual (Static Budget) Number of tablets produced and sold 30.000 $0.500 Sales Price [E per tablet] 450 440 Units of Screen purchased and used $1.500 $3.245 Fixed operating costs ] 1.700.000 .700,000 Variable operating costs [E per 260 250 screen # Year 0 1 2 3 4 9 10 Discount factor Net initial investments operating cash 2 flow Cash flow from 2.1 operations ncome tax cash savings from depreciation 2.2 deductions erminal disposal 3 price Total annual cash 4 flows Discounted annual 5 cash flows NPV DepreciationExercise 1. Lap Tech Inc. (32 points) Table 2. Forecasted and actual operating data Data Project Forecast (Static Budget) Project Actual Number of tablets 30,000 30,500 produced and Sales Price [E per 450 140 tablet] Units of Screen purchased and 31,500 33,245 used Fixed operating 4,700,000 4,700,000 costs [{] Variable operating costs [E 260 250 8 per screen] Question 2a in [E] 12 Standard quantity Flexible budget 3 (Standard cost) 5 Question 2b in [(] Please choose from dropdown list 6 Cost variance Volume effect 8 Question 2d in [E] Please choose from dropdown list Price Variance 21 Quantity VarianceSuppose that the top-management of the company approved the project. At the end of the first year, the manager of the Tablet Division observes the actual results (see Table 2). In order to evaluate the performance of the production department and its two managers (the procurement manager, who is responsible for purchasing materials, and the assembly manager, who is responsible for running an efficient assembly process), he asks you to conduct a variance analysis. 2. Variance Analysis (17 points) a. Calculate the flexible budget (i.e., standard cost budget) based on the actual number of tablets produced. Hint: first determine the standard quantity based on the actual number of tablets produced. (3 points) b. Calculate the cost variance based on the flexible budget. How large is the volume effect? (4 points) c. Why is it important for Lap Tech Inc. to calculate the cost variance based on a flexible budget? (2 points) d. Calculate price variance and quantity variance. Are these variances favorable or unfavorable? What do these variances suggest about the performance of the assembly and the procurement manager? (4 points) e. Do the price variance and the quantity variance add up to the total cost variance? What would you recommend the company to do with potential differences between the total cost variance and the sum of the price and quantity variance? Should the managers be responsible for the difference in the variance? (4 points) Open the Excel file and do your calculations in the "Question 2" spreadsheet.Exercise 1. Lap Tech Inc. (32 points) Please download Excel file "SMCS_Exercise_1.xisx" and conduct your calculations there. Please name the Excel file with your solutions as "SMCS_Exercise_1_youridnumber.xlex" and upload it. You do not have to show calculations in the boxes below the questions. The manufacturing company LapTech Inc. is considering to launch a new tablet. For the production of tablets, the company needs a new machine to assemble a special screen to the tablet. The manager of the Tablet Division is requested to prepare a forecast to evaluate whether such an investment would be beneficial. The forecast data provided by the manager is presented in Table 1 and Table 2. Table 1. Forecasted and actual data for the project Data Project Forecast (Static Budget) Project Actual Net initial investment [(] 3,000,000 3,000,000 Useful life [years] 10 10 Terminal disposal value [(] 0 0 RRR [%] 10% 10% Income tax rate [%] 30% 30% Depreciation Straight line Straight line Table 2. Forecasted and actual operating data Data Project Forecast (Static Budget) Project Actual Number of Tablets produced and sold 30,000 30,500 Sales Price [( per Tablet] 450 440 Units of Screen purchased and used 31,500 33,245 Fixed operating costs [(] 4,700,000 4, 700,000 Variable operating costs [( per Screen] 260 250