Hi, I'm not sure if my calculations are correct on my excel so could you answer the following question using excel so I can compare? My absorption costing net profit is significantly lower than my variable costing net profit, so I'm a little uncertain of my answer.

"417.3 Intermediate: Preparation of variable and absorption ousting statements. Solo Limited makes and sells a single product. The following data relate to periods 1 to 4: (J Variable cost per unit 30 Selling price per unit 55 Fixed costs per period 6000 Normal activity is 500 units and production and sales for the four periods are as follows: Period Period Period Period 1 units 2 units 3 units 4 units Sales 500 400 550 450 Production 500 500 450 500 There were no opening stocks at the start of period 1. Required: (a) Prepare operating statements for EACH of the periods 1 to 4, based on marginal costing principles. (4 marks) (b) Prepare operating statements for EACH of the periods 1 to 4, based on absorption costing principles. (6 marks) (c) Comment briefly on the results obtained in each period AND in total by the two systems. (5 marks) CIMA Stage 1 Cost Accounting