Question: i need to know what data (which cells) you used in order to obtain specific numbers since I have to put formulas manually. thanks! i


Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two products lines, Economy and Deluxe, are shown below. Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. Jse formulas to assign overhead to each product using both activity rates and activity proportions (X). Create If statements to verify that the two methods produce the same results. (The first If statement is given) Note: Use cell A2 from the given information to complete this question. Students: The scratchoad area is for vou to do anw additional work vou need to solve this cuestion or can be used to shaw vour work. 8 Graded Worksheet + Sundial Company has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two products lines, Economy and Deluxe, are shown below. Input formulas to solve for the various unknowns in the table below. The formulas may vary for each cost pool depending on what items are known and unknown. Assign indirect costs to products or services using activity based costing. Note: Use cell A2 from the given information to complete this question. Jse formulas to assign overhead to each product using both activity rates and activity proportions (X). Create If statements to verify that the two methods produce the same results. (The first If statement is given) Note: Use cell A2 from the given information to complete this question. Students: The scratchoad area is for vou to do anw additional work vou need to solve this cuestion or can be used to shaw vour work. 8 Graded Worksheet +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
