contation Corps projede production and sales in us for the three months. ending 175 as a follow May June July Production 3000 120000 110000 129000 101.000 10000 Cash related production costs are budgeted at $17 per un pedofiles production couse poin the most in which they are incurred and the balance in the blowing months per il conto 10000 per month. The counts payable balance on May total 79.000 which will be paid in May Alise old count for $35 coch. Can Collection from are based at sine month of sale in the month fotowo the roof andering in the condo month of Account create on Myotid 5.0 of which is to Mars the remainde from April Required: Peale sede forced Contences wide wolno todos 2. Prepare the mother doch receptor Cortion Show who made in Part 1 Como com o produits for the main as fotos May June July Production 10.000 120,000 110,000 Ses 120,000 102.000 110,000 Gated costs bude 17 ani produced Option.com, Bald in the month in whitey are curred and the balance in the following month Selling and administrative pe wil onto pronth the court weblance on May 1, which will be paid in My All in while bome are budget in the month of sale on the month following the month of mind the remain in the second month following the the way of which was from Marchis sales and the remainder from All Required prachowing ulted chants for the station Comptes with no decimal placer dans for doigures. It polna for oth tutorted cash for Contato Corp Showaltures with no decin place wign for dataoures Point Constitution Company's standart and actual costs pet ut for the most recent period are given below. 15,000 units were actually produced Standard Actual Materials: Standardfeet at $2.00 per foot $10.00 Actual 2 feet at $1.50 per foot 5936 Direct Labor Standard 3 hours at 5250 per hour 5930 Actual 15 hours at 500 per hour 51050 Required trong cute the following and indicate whether the new or unable. Show all figures out to two decimal places. Use dollar signs for dollar figure Wie o Part Leplan how contand prices quantes, tousetr.) e established points) Wythe total de la vianos dvided into a cale variance and an efficiency wariance point What are really in the best position to once the direct laborelliency variance(t point) Additional Guidance and instruction on the pare worth in the one worksheet for Part 1, second worksheet for Part 2 and a third worksheet for Part 3 www.compon to capport your Le Blog Contoure You ACC419 120 W nyo ponowny color your font de nou any colon ore to shade any cells be your need.com corteve your en in de status. You are required to acknowledge that the work you are submitting is your own copying staring, working cum te wachometown family.c) is prohibited Supected violations may be submitted to the Academic Conduct Committee for review reaction and presentation will be considered in determining your gode for this signment Constellation Corp. has projected production and sales in units for the three months ending 7/31 as as follows: June Production May 140,000 120,000 120,000 103,000 July 110,000 130,000 Sales Cash-related production costs are budgeted at $17 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $95,000 per month. The accounts payable balance on May 1 totals $395,000, which will be paid in May. All units are sold on account for $35 each. Cash collections from sales are budgeted at 65% in the month of sale, 20% in the month following the month of sale, and the remaining 15% in the second month following the month of sale. Accounts receivable on May 1 totaled $650,000 of which $185,000 was from March's sales and the remainder from April. Required: 1. Prepare a schedule for each month showing budgeted cash disbursements for the Constellation Corp. Show all figures with no decimal places. Use dollar signs for dollar figures 2. Prepare a schedule for each month showing budgeted cash receipts for Constellation Corp. Show all figures with no decimal places. Use dollar signs for dollar figures. Part 2 Constitution Company's standard and actual costs per unit for the most recent period are given below. 15,000 units were actually produced. Constitution Company's standard and actual costs per unit for the most recent period are given below. 15,000 units were actually produced Standard Actual Materials: Standard: 5 feet at $2.00 per foot Actual: 5.2 feet at $1.80 per foot $10.00 $9.36 Direct Labor: $9.38 Standard: 3.75 hours at $2.50 per hour Actual: 3.5 hours at $3.00 per hour $10.50 Required: From the foregoing information, compute the following variances and indicate whether the variances are favorable or unfavorable. Show all figures out to two decimal places. Use dollar signs for dollar figures. 1. Materials price variance. 2. Materials quantity variance. 3. Direct labor rate variance 4. Direct labor efficiency variance i Part 3 1. Briefly explain how cost standards (i.e, prices, rates, quantities, hours, etc.) are established. I 2. Why is the total direct labor variance divided into a rate variance and an efficiency variance? 3. What manager is generally in the best position to influence the direct-labor efficiency variance