Complete tenor 8-21 (competency 1-4 singly) and practices 17-20 to 17-22 in the textbook. Prepare your responses in Excel delay each tenor on a disjoined tab. Tenor 8–21 Straightforward Tenor on Parching versus Fickle Costing (LO 2, 3, 4) 2(a). Net proceeds: $200,0003. Absorb of property sold lowerneathneath parching absorbing: $1,500,000 Skinny Dippers, Inc. produces nonfat frozen yogurt. The effect is sold in five-gallon containers, which keep the forthcoming absorb and fickle absorbs. Sales absorb 15 Direct embodied 5 Direct work 2 Fickle over 3 Budgeted urban over in 20x1, the congregation’s primitive year of formations, was $300,000. Planned and express effection was 150,000 five-gallon containers, of which 125,000 were sold. Skinny Dippers, Inc. incurred the forthcoming dispose-ofing and functional expenses. Urban 50,000 for the year Fickle $1 per container sold Required: 1. Compute the effect absorb per container of frozen yogurt lowerneathneath ( a ) fickle absorbing and ( b ) parching absorbing. 2. Prepare proceeds statements for 20x1 using ( a ) parching absorbing and ( b ) fickle absorbing. 3. Reconcile the proceeds reported lowerneathneath the two ways by listing the two key places where the proceeds statements dissent. 4. Reconcile the proceeds reported lowerneathneath the two ways using the shortcut way. 5. Build a spreadsheet: Construct an Excel spreadsheet to work-out all of the foregoing requirements. Show how the disconnection succeed shift if the forthcoming notification shifts: the dispose-ofing absorb and direct-embodied absorb per individual are $16.00 and $4.50, respectively. Practice 17–20 Physical-Units Method; Elbow Absorb Allocation Breakfasttime Cereal Congregation manufactures two breakfast cereals in a elbow arrangement. Absorb and muchness notification is as follows: Elbow Absorb Cereal Muchness at Split-off purpose $30,000 Yummies 12,000 kilograms Crummies 8,000 kilograms SalesPriceperKilogram $2.00 - Yummies 2.50 - Crummies Required: Use the physical-units way to arrange the congregation’s elbow effection absorb among Yummies and Crummies. Practice 17–21 Relative-Sales-Value Method; Elbow Absorb Allocation Refer to the axioms consecrated in the foregoing practice. Required: Use the relative-sales-value way to arrange Breakfasttime Cereal Company’s elbow effection absorb among Yummies and Crummies. Practice 17–22 Net-Realizable-Value Method; Elbow Absorb Allocation Refer to the axioms consecrated in Practice 17–20 . Breakfasttime Cereal Congregation has an opening to arrangement its Crummies advance into a mulch for ornamental shrubs. The concomitant arrangementing formation absorbs $.50 per kilogram, and the mulch succeed dispose-of for $3.50 per kilogram. Required: 1. Should Breakfasttime’s skillful-treatment run to arrangement Crummies into the mulch? Why? 2. Suppose the congregation does arrangement Crummies into the mulch. Use the net-realizable-value way to arrange the elbow effection absorb among the mulch and the Yummies.