Unit: Advanced Management Accounting
10 Questions| 1 | Regression analysis performed using MS Excel in a computer yielded the following results: |
| Summary of output Regression statistics | ||
| Parameter | Output | |
| Multiple R | 0.984523 | |
| R square | 0.969285 | |
| Adjusted R square | 0.961607 | |
| Standard Error | 32.196570 | |
| Observations | 6 | |
| 2. | The analysis of variance (ANOVA) output was as follows: | |
Predictor | df | SS | MS | F | Significance F | ||
| Regression | 1 | 130853.5 | 130853.5 | 126.2311 | 0.000357 | ||
| Residual | 4 | 4146.476 | X | ||||
| Total | 5 | 135000 | |||||
Variable | Coefficients | Standard error | t-statistic | P-value | Lower 95% | Upper 95% | |
| Intercept | 509.9119 | 45.55789 | Y | 0.000363 | 383.4227 | 636.4011 | |
| Variable X | 29.40529 | 2.617232 | 11.23526 | 0.000357 | 22.13867 | 36.6719 |
| Variable costs: | Sh. |
| Direct labour | 33 |
| Direct material | 77 |
| Marginal cost | 110 |
| Fixed costs: | |
| Production overheads | 100 |
| Full cost | 210 |
| Sh. | ||
| Selling price per unit | 880 | |
| Cost per unit: | ||
| Direct material: A | (2 kgs at Sh.100 per kg) | 200 |
| Direct.material:.B | (1 litre at Sh.150 per litre) | 150 |
| Direct labour | (3 hours at Sh.90 per hour) | 270 |
| Variable overhead | (3 hours at Sh.20 per direct labour hour) | 60 |
| 1. | Zeta Ltd. budgeted sales and production for the month of July 2023 was 10,000 units. |
| 2. | Annual budgeted fixed overheads were Sh.14,400,000 which are assumed to be incurred evenly throughout the year. |
| 3. | The company uses marginal costing system for internal profit measurement purposes. |
| 4. | The actual data for the month of July 2023 were as follows: | |
| Actual production and units sold | 9,000 Units | |
| Selling price | Sh.900 | |
| Direct materials consumed: | ||
| A: 19,000 kgs consumed at a cost of Sh.2,090,000 | ||
| B: 10,100 litres consumed at a cost of Sh.1,414,000 | ||
| Direct labour incurred 28,500 hours at a cost of Sh.2,736,000 | ||
| Variable overheads incurred | Sh.520,000 | |
| Fixed overheads incurred | Sh.1,160,000 | |
| Net profit/(loss) | |||
| Market conditions | Poor | Fair | Good |
| Probability of market states | 30% | 40% | 30% |
| Number of sandwiches sold: | Sh. | Sh. | Sh. |
| 100,000 | 100,000 | 300,000 | 300,000 |
| 200,000 | (100,000) | 600,000 | 600,000 |
| 300,000 | 0 | 700,000 | 900,000 |
| 400,000 | (300,000) | 600,000 | 1,200,000 |
| 1. | The estimated demand is 60,000 bottles per year. |
| 2. | The opportunity cost of running out of stock is Sh.55. |
| 3. | The lead-time is 5 days guaranteed. |
| 4. | The cost of holding a bottle is Sh.50 per year. |
| 5. | The number of orders per annum are 10 orders. |
| 6. | The demand figures for the last 20 weeks are as follows: | |
| Sanitiser bottles sold | Number of days the level of sales occurred | |
| 150 | 7 | |
| 200 | 14 | |
| 250 | 35 | |
| 300 | 35 | |
| 350 | 28 | |
| 400 | 14 | |
| 450 | 7 | |
| 7. | At present, Sanitiza Ltd. uses a re-order level of 250 sanitiser bottles and does not carry any safety stock because of the guaranteed delivery time. |
| Product A | Product B | Product C | |
| Annual sales (units) | 6,000 | 6,000 | 1,000 |
| Selling price (Sh.) | 200 | 320 | 400 |
| Unit cost (Sh.) | 180 | 240 | 300 |
| Processing time required per unit (hours ) | 1 | 1.5 | 2 |
| 1. | The firm is working at full capacity of 17,000 processing hours per year. |
| 2. | Fixed costs are absorbed into unit cost by a charge of 200% of variable cost. |
| 3. | Processing can be switched from one product line to another. |
| 4. | The selling prices are not to be altered. |
| 5 | Information in respect to the maximum demand for each product which Rona Enterprise could alternatively outsource from an independent supplier, for the same quality, is given below at current selling prices: |
| 5. | Product | Expected maximum demand (Units) | Quoted price (Sh.) |
| A | 11,000 | 175 | |
| B | 8,000 | 240 | |
| C | 2,000 | 320 |
| 6. | In the period commencing 1 September 2022 and ending 31 August 2023, the company budgeted for production fixed overheads of Sh.2,000,000. |
Required: | |
| (i) | Compute the shortfall of the limiting factor. |
| (ii) | Determine the optimal production mix indicating the products and quantity to outsource from external supplier. |
| (iii) | Based on your recommendations in (b) (ii) above, determine the net profit for the period 31 August 2023. |
Want to join the discussion?
Log in to post comments and interact with tutors.
Login to Comment