Can someone perform all the calculations to this problem in an Excel spreadsheet using cell refrencing and formulas?
Please and Thank you!!
Becton Lobs, Inc, produces various chemical compounds for industrial use. One compound, called Fludex, is prepared using an elaborate distilling process. The company has developed standard costs for one unit of Fludex, as follows: Standard Quantity Standard Price Standard or Hours or Rate Cost Direct materiala 2.50 ounces $19.00 per ounce $47.50 Direct labor 0.70 hours $15.00 per hour 10.50 Variable manufacturing overhead 0.70 hours $ 4.00 per hour 2.80 Total standard cost per unit $60.00 During November, the following activity was recorded related to the production of Fludex: a. Materials purchased, 12,500 ounces at a cost of $223,125, b. There was no beginning inventory of materials; however, ot the end of the month, 3,250 ounces of material remained in ending Inventory c. The company employs 21 lab technicians to work on the production of Fludex. During November, they each worked an average of 150 hours at an average pay rate of $12.50 per hour d. Variable manufacturing overhead is assigned to Fludex on the basis of direct labor-hours. Variable manufacturing overhead costs during November totaled $5,100. e. During November, the company produced 3,500 units of Fludex, Required: 1. For direct materials: a Compute the price and quantity variances. b. The materials were purchased from a new supplier who is anxious to enter into a long-term purchase contract. Would you recommend that the company sign the contract? 2. For direct labor a. Compute the rate and efficiency variances. b. In the past, the 21 technicians employed in the production of Fludex consisted of 4 senior technicians and 17 assistants. During November, the company experimented with fewer senior technicians and more assistants in order to reduce labor costs. Would you recommend that the new labor mix be continued? 3. Compute the variable overhead rate and efficiency variances. Req 1A Req 1B Reg 2A Req 2B Req3 For direct materials, compute the price and quantity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Materials price variance Materials quantity variance 14,375 9,500U 3 RoqnA Req 1B > Reg 1A Req 1B Reg 2A Req 2B Reg 3 For direct materials, the materials were purchased from a new supplier who is anxious to enter into a long-term purchase contract. Would you recommend that the company sign the contract? Yes ONO Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Req 2A Req 2B Req3 For direct labor, compute the rate and efficiency variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (ie, zero variance). Input all amounts as positive values.) Labor rate variance Labor efficiency variance 7,875 10,500 U Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Reg 2A Req 2B Req3 In the past, the 21 technicians employed in the production of Fludex consisted of 4 senior technicians and 17 assistants. During November, the company experimented with fewer senior technicians and more assistants in order to reduce labor costs. Would you recommend that the new labor mix be continued? Yes No Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Req 2A Reg 28 Reg 3 Compute the variable overhead rate and efficiency variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero variance). Input all amounts as positive values.) Variable overhead rate variance Variable overhead efficiency variance 7,500 2,800 F u
