Assembly Department $15$ machine hours Required: Question Content Area $1.$ Complete the following table by calculating the sawmill's cost per board for each grade using both the physical units method and the sales$-$value$-$at$-$split$-$off method. Begin by allocating the joint manufacturing costs to each grade, and calculate the cost per board foot for each grade using each method. Round unit cost answers to two decimal places. a$.$ Physical units method of allocation: Grades Allocation Unit Cost Firsts and seconds $fill in the blank $180,000$ $fill in the blank $0\mathrm{.}12$ No$.1$ common fill in the blank e$9$ade$307303100$d$\_3360,000$ fill in the blank e$9$ade$307303100$d$\_40\mathrm{.}12$ No$.2$ common fill in the blank e$9$ade$307303100$d$\_5225,000$ fill in the blank e$9$ade$307303100$d$\_60\mathrm{.}12$ No$.3$ common fill in the blank e$9$ade$307303100$d$\_7135,000$ fill in the blank e$9$ade$307303100$d$\_80\mathrm{.}12$ Totals $fill in the blank e$9$ade$307303100$d$\_9900,000$ Sales$-$value$-$at$-$split$-$off method: Grades Allocation Unit Cost Firsts and seconds $fill in the blank $0\mathrm{.}18$ No$.1$ common fill in the blank fill in the blank e$9$ade$307303100$d$\_130\mathrm{.}14$ No$.2$ common fill in the blank fill in the blank e$9$ade$307303100$d$\_150\mathrm{.}08$ No$.3$ common fill in the blank e$9$ade$307303100$d$\_1667,500$ fill in the blank e$9$ade$307303100$d$\_170\mathrm{.}06$ Total $fill in the blank e$9$ade$307303100$d$\_18900,000$ Sawmill Cost and Production Data Grade Physical Units Method: Cost per Board Foot Sales$-$Value$-$at$-$Split$-$Off Method: Cost per Board Foot Firsts and seconds $fill in the blank e$9$ade$307303100$d$\_190\mathrm{.}12$ $fill in the blank e$9$ade$307303100$d$\_200\mathrm{.}18$ No$.1$ common fill in the blank e$9$ade$307303100$d$\_210\mathrm{.}12$ fill in the blank e$9$ade$307303100$d$\_220\mathrm{.}14$ No$.2$ common fill in the blank e$9$ade$307303100$d$\_230\mathrm{.}12$ fill in the blank e$9$ade$307303100$d$\_240\mathrm{.}08$ No$.3$ common fill in the blank e$9$ade$307303100$d$\_250\mathrm{.}12$ fill in the blank e$9$ade$307303100$d$\_260\mathrm{.}06$ b$.$ Given that the sawmill provides lumber at cost to the furniture plant, using the sales$-$value$-$at$-$split$-$off method increases the cost of Job A$500$ by $fill in the blank e$9$ade$307303100$d$\_28$ and increases the cost of Job B$75$ by $fill in the blank e$9$ade$307303100$d$\_30.$ c$.$ The physical units method, often used in the lumber industry, essentially assumes that it costs the same to produce each board foot regardless of the grade. Thus, the same cost of lumber would be assigned to a sofa or chair regardless of which grade is used. This approach has some drawbacks. Intuitively, the higher grades should cost more $.$ Certainly, if the company was buying this input from suppliers, there would be a cost difference for sofas and chairs depending on the grade of lumber purchased, because the higher grades have a higher selling price. The relative sales value method assigns a higher cost to grades that have a higher market value. Thus, the cost assigned to sofas and chairs would differ according to the grade of lumber used. d$.$ Review the data analytic concepts and metrics found in Exhibits $2\mathrm{.}5$ and $2\mathrm{.}6,$ pp$.37,40.$ What are the data analytic models being considered for the Sawmill? Physical units method Which of the data analytic types is being used in Part a of Requirement $1?$ Descriptive And for Part b$?$ Diagnostic and Predictive Part c$?$ Descriptive Note: More than one data analytic type may apply. Which of the data analytic models in play would you recommend for assigning the joint manufacturing sawmill costs? Descriptive, Diagnostic and Predictive $2.$ Calculate the plantwide overhead rate for the fabric plant. $fill in the blank e$9$ade$307303100$d$\_4810$ per hour Calculate the amount of under$-$ or overapplied overhead for the fabric plant. $fill in the blank e$9$ade$307303100$d$\_4930,000$ overapplied $3.$ a$.$ Using the weighted average method, complete the following information regarding the Weaving and Pattern production process: i$.$ Physical flow schedule $($measured in yards$)$ fill in the blank e$9$ade$307303100$d$\_51100,000$ ii$.$ Materials fill in the blank e$9$ade$307303100$d$\_52100,000$ Conversion Costs fill in the blank e$9$ade$307303100$d$\_5388,000$ iii. Unit cost $fill in the blank e$9$ade$307303100$d$\_54$ iv$.$ Cost of goods transferred out $fill in the blank e$9$ade$307303100$d$\_55$ b$.$ To convert the output of the Weaving and Pattern Department to the output of the Coloring and Bolting Department, yards transferred is divided by fill in the blank e$9$ade$307303100$d$\_57$ c$.$ Using the weighted average method, complete the following for the Coloring and Bolting Department: i$.$ Physical flow schedule $($measured in bolts$)$ fill in the blank e$9$ade$307303100$d$\_58$ Transferred$-$in Materials Mater

being of the community is tied ver

Sawmill:

Joint manufacturing costs: $$900,000$

Fabric Plant:

Budgeted overhead: $$1,200,000(50\%$ fixed$)$

Practical volume $($direct labor hours$)$: $120,000$ hours

Actual overhead: $$1,150,000(50\%$ fixed$)$

Actual hours worked:

Departmental data on Fabric FB$70($actual costs and actual outcomes$)$:

Pattern

Bolting

process. The cost of the rods is relatively ins

pr