Archivo Inicio Insertar Dibujar Disposicin de pgina Frmulas Datos Con Copiar AA NKS care formate Fuerte Problem Set 3. (20 points) 1. Fill out the basks in color. If no answer key is needed, just leave the Mank Der fom Moneda Combanery centrat $ condicional + samo table Nime 7 lach cel MUST mchede o formula Ank, or a working process, except for the given number from the questions) 3. Dinctly typing only the answers on the cell won't get the full credits (except for given numbers from the questions) Sharing ansers and Mes will result in the Zwo Grade both giver and receiver Plagiarism will be checked) A Company as a standard cost system. The month's data regarding its product in actual and standard as follow Deathmatcost per pund 15 Standard 10 Acteal 0.97 13 12 el parched and used in total tit (pound) Din per unit of input 15 3,300 7.70 Direct material cost per pound 5) Direct material ined in a unit (pound) Direct labor rates per unit ut input (5) 100 100 800 Daber sinced in total output prouts 5,500 Direct labor uned in a unit (hour) 5.00 Vile overtad cost incurred in total uit d 4,600 Variable overhead cast in total 15) 4,000 Food head cost cured in total outpu 7.200 Fand overhead cost in total (S 1,350 The units produced for actual output during the month were 1,000 19 20 21 Requirement 1. Prepare the following schedules and all variances, and analyze the results Supporing Schedule Actual and Standard data. 223 23 Standed Data Standard Price Standard Quantity per unit of input Usts of Actual Output level 24 25 Det er 5 hour Price and Quantity 27 at Acutal and Standard Actual Price Actual Quantity per unit of input d for Output Standard Price per unit of input Standard Quantity of Output lever IN 29 Oryct labor Ston Variable Ovested 4,000 Cat der ed Viatic Overhead: Drest labor hours Flexible Budget Variances Fest Variance Actual Cost Flexible Wined FAU Flexible Budget Pike Rate, Spending) and Quantity (Usage, Efficiency) Variances V 4 147 M Pate Standard Press Ganity age Spendingl Actual Quantities Variance ed for Out Effec Vince F/U Feville Budget Requirement 2 You are an upper manager of the production manager who is reponsible for the budget variances Flexible t Valance 170 Archi 8- 2000 ACCE20 Final Audi S1010-Excal Base Inicio eta Obujer Diposicin de pgina Formulas Dutos Revisar Vista Ayida NKS 345 D 4 3 Conry Moneda Requirement 2. You are an apper manager of the production manager who is reponsible for the budget variances Requirement 2-1 Analyze the direct material cost variances and give the production manager a right feedback related to the price and quantity variances Requirement 2-2 Analyse the direct labor cost variances and give the production manager a right feedback related to the rate and usage variances Requirement 2-3 Analyze the variable overhead cost variances and give the production manager a right feedback related to the spending and efficiency variances Requirement 2-4 Analyze the fand overhead cost variances and give the production manager a right feedback related to the spending ond efficiency varios The End of the Problem Set 3 T D& Problem Set 3. (20 points) 1. Fill out the blanks in color. If no answer key is needed, just leave the blank. 2. Each cell MUST include a formula, link, or a working process. (except for the given number from the questions) 3. Directly typing only the answers on the cell won't get the full credits. (except for given numbers from the questions) 4. Sharing answers and files will result in the Zero Grade both giver and receiver. (Plagiarism will be checked) ABC Company uses a standard cost system. The month's data regarding its product in actual and standard as follow: Actual Direct material cost per pound (5) 0.97 Material purchased and used in total output (pound) 3,300 Direct labor rates per unit of input (5) 7.70 Direct labor hours incurred in total output (hours) 5,500 Variable overhead cost incurred in total ouput (S) 4,620 Fixed overhead cost incurred in total output(S) 7,200 "The units produced for actual output during the month were 1,000. Standard Direct material cost per pound (5) Direct material used in a unit (pound) Direct labor rates per unit of input (5) Direct labor used in a unit (hour) Variable overhead cost in total (5) Fixed overhead cost in total (5) Requirement 1. Prepare the following schedules and all variances, and analyze the results. Supporing Schedule. Actual and Standard data. Standard Data Standard Price per unit of Input Standard Quantity per unit Direct material cost (5, pound) Direct labor cost (S, hour) Units of Actual Output level Standard Quantity Price and Quantity Actual Price of Acutal and Standard per unit of Input Actual Quantity used for Output Standard Price per unit of Input of Output level achieved Direct material cost (5, pound) Direct labor cost (5, hour) Variable Overhead (S, hour") "Cost driver of Variable Overhead: Direct labor hours Flexible Budget Variances. Flexible Budget Variance Actual Cost Incurred: Flexible Budget Variance F/U Flexible Budget: Direct material cost (S, pound) Direct labor cost (5, hour) Variable overhead cost (5, hour) Fixed overhead cost Price (Rate, Spending) and Quantity (Usage, Efficiency) Variances. Variances Direct material cost Direct labor cost Variable overhead cost Fixed overhead cost Actual Cost Incurred Price (Rate, Spending) Variance F/U 1.00 3.00 8.00 5.00 4,000 7,350 Standard Prices x Actual Quantities used for Output Quantity (Usage, Efficiency) Variance Flexible Budget F/U Flexible Budget Variances F/U Problem Set 3. (20 points) 1. Fill out the blanks in color. If no answer key is needed, just leave the blank. 2. Each cell MUST include a formula, link, or a working process. (except for the given number from the questions) 3. Directly typing only the answers on the cell won't get the full credits. (except for given numbers from the questions) 4. Sharing answers and files will result in the Zero Grade both giver and receiver. (Plagiarism will be checked) ABC Company uses a standard cost system. The month's data regarding its product in actual and standard as follow: Actual Direct material cost per pound (S) Standard Material purchased and used in total output (pound) Direct labor rates per unit of input (S) Direct labor hours incurred in total output (hours) - Variable overhead cost incurred in total ouput (S) Fixed overhead cost incurred in total output(S) 0.97 3,300 7.70 5,500 4,620 7,200 Direct material cost per pound (5) Direct material used in a unit (pound) Direct labor rates per unit of input ($) Direct labor used in a unit (hour) Variable overhead cost in total (S) Fixed overhead cost in total (5) 1.00 3.00 8.00 5.00 4,000 7,350 *The units produced for actual output during the month were 1,000. Requirement 1. Prepare the following schedules and all variances, and analyze the results. Supporing Schedule. Actual and Standard data. Standard Data Direct material cost (5, pound) Standard Price Standard Quantity per unit of Input per unit Units of Actual Output level Direct labor cost (S, hour) Price and Quantity of Acutal and Standard Direct material cost (S, pound) Direct labor cost (S, hour) Actual Price: per unit of Input Actual Quantity used for Output Standard Price per unit of Input Standard Quantity of Output level achieved DELL Supporing Schedule. Actual and Standard data. Standard Data Standard Price per unit of Input Standard Quantity per unit Units of Actual Output level Direct material cost (S, pound) Direct labor cost (S, hour) Standard Quantity Price and Quantity Actual Price of Acutal and Standard per unit of Input Actual Quantity used for Output Standard Price of Output level per unit of Input achieved Direct material cost ($, pound) Direct labor cost (S, hour) Variable Overhead (5, hour*) "Cost driver of Variable Overhead: Direct labor hours Flexible Budget Variances. Flexible Budget Variance Actual Cost Incurred: Flexible Budget Variance F/U Flexible Budget: Direct material cost ($, pound) Direct labor cost ($, hour) Variable overhead cost (5, hour) Fixed overhead cost Price (Rate, Spending) and Quantity (Usage, Efficiency) Variances. Variances Direct material cost Direct labor cost Variable overhead cost Fixed overhead cost Actual Cost Incurred Price (Rate, Spending) Variance F/U Standard Prices Quantity (Usage, x Actual Quantities used for Output Efficiency) Flexible Budge Variance F/U Flexible Budget Variance Requirement 2. You are an upper manager of the production manager who is reponsible for the budget variances. DELL Q Flexible Budget Variance Incurred: Variance F/U Flexible Budget: Direct material cost (S, pound) Direct labor cost (5, hour) Variable overhead cost (5, hour) Fixed overhead cost Price (Rate, Spending) and Quantity (Usage, Efficiency) Variances. Price (Rate, Variances Direct material cost Direct labor cost Variable overhead cost Fixed overhead cost Actual Cost Incurred Spending) Variance F/U Standard Prices x Actual Quantities used for Output Quantity (Usage, Efficiency) Variance F/U Flexible Budget Flexible Budget Variances F/U Requirement 2. You are an upper manager of the production manager who is reponsible for the budget variances. Requirement 2-1. Analyze the direct material cost variances and give the production manager a right feedback related to the price and quantity variances. Requirement 2-2. Analyze the direct labor cost variances and give the production manager a right feedback related to the rate and usage variances Requirement 2-3. Analyze the variable overhead cost variances and give the production manager a right feedback related to the spending and efficiency varia Requirement 2-4. Analyze the fixed overhead cost variances and give the production manager a right feedback related to the spending and efficiency variance The End of the Problem Set 3 Total DELL