I NEED HELP FOR QUESTION F Go to the tab titled $$Plantwide Approach:$$

a$.$ Create a formula that calculates the direct labor$-$hours in the denominator of the plantwide overhead rate $($cell F$3).$ Also, create a formula that calculates the plantwide overhead rate $($cell F$4).$ What formulas correctly calculate these two amounts?

b$.$ What is the plantwide overhead rate?

c$.$ Create the appropriate formulas $($within cells B$11$ through D$17)$ to compute the gross margins for the Standard and Advanced models as well as the company as a whole. What formulas correctly calculate the direct materials, direct labor, and manufacturing overhead for the Standard model?

d$.$ What are the gross margins for the Standard model $($cell B$17)$ and the Advanced model $($cell C$17)?$

e$.$ Using Charts, create a pie chart that shows the percent of total manufacturing overhead cost allocated to each product using the plantwide approach. $($Your instructor may require you to upload this file in Part $6).$

f$.$ What percent of the total manufacturing overhead cost is allocated to the Standard model using the plantwide approach? The Advanced model?