ANSWER QUESTION 3 ONLY IN EXCEL

Abam Bakery Enterprise is a small bakery manufacturer located at Ipoh, Perak. Currently, Abam Bakery produces three types of product - brownies, cupcakes and filing donuts. There are three production departments. Departmental information on budgeted overhead and various activity measures for the coming year is as follows: Mixing Cooking Packaging Estimated overhead RM300,000 RM150,000 RM220,000 Direct labor hours 4,500 15,000 3,200 Direct labor cost RM120,000 RM180,000 RM120,000 Machine hours 8,000 2,000 5,000 Currently, overhead is applied on the basis of machine hours using a plantwide rate. However, the production supervisor, Miss Lily, has been wondering whether it might be worthwhile to use departmental overhead rates. She has analysed the overhead costs and drivers for the various departments and decided that Mixing and Packaging should base their overhead rates on machine hours and that Cooking should base its overhead rate on direct labor hours. Miss Lily has been asked to prepare bids for two job offers with the following information: Job 1 Job 2 Direct materials RM12,200 RM16,500 Direct labor cost RM4,200 RM6.800 Direct labor hours: Mixing 30 20 Cooking 150 80 Packaging 20 100 Number of machine hours: Mixing 150 Cooking 80 50 Packaging 250 The typical bid price includes a 45% markup over full manufacturing cost. Round all overhead rates to the nearest cents. Round all bid prices to the nearest ringgit. 100 170 REQUIRED: 1) Calculate a plantwide rate for Syarikat Techno based on machine hours. What is the bid price of each job using this rate? 2) Calculate departmental overhead rates for the three producing departments. What is the bid price of each job using these rates? 3 3) What If Analysis: (a) Repeat Requirement (1) and (2), if the bid price includes a 30% markup over the full manufacturing cost