Question

All answers must be entered as a formula. Click OK to begin. Om

1. Assign indirect costs to products or services using activity based costing. X 5 Assigning indirect costs to products or se

Proportion %) Overhead Cost $ 300,000 $ 210,000 Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Powe

D G H 1 K Cost Driver Material moves Proportion (%) Activity Rate per move per set-up $ 12.50 per hour per sq. ft. Set-ups Ac

fill in the yellow shaded area with formulas only!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A B C D E F G H 1 wn- 4 Activity Cost Pool 5 Material Handling 6 Machine Set-Ups 7 Engineering Support 8 Power and Space 9 ToА B C D E F G H 1 J K L 11 12 13 Overhead Assigned Using Activity Proporions (%) Economy Deluxe Total =B5*H5 =B5*15 =F16+G

Add a comment
Know the answer?
Add Answer to:
fill in the yellow shaded area with formulas only! All answers must be entered as a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • can you please show me the formula you use for each yellow highlighted? how do you...

    can you please show me the formula you use for each yellow highlighted? how do you enter it on excel? 4 1 Sundial Co, 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 bel 2 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. Calibri 11 A A 29 Wrap...

    Assign indirect costs to products or services using activity-based costing. Calibri 11 A A 29 Wrap Text General Paste BIU- 30 Merge & Center - $ % Insert Delete Format 1 68 69 Conditional Format as Cell Formatting - Table Styles - Styles Clipboard Font Alignment Number Cells A1 v fi Sundial Co. has assigned $710,000 in total overhead cost to four different activity cost pools. The activity requirements for its two products lines, Economy А B с D E...

  • please write the formuals in this format for example : =B2+C6 and so on,.... use the...

    please write the formuals in this format for example : =B2+C6 and so on,.... use the cell number and letters that are showen in the picture. dont change the numbers and letters please! thank you 1. Assign indirect costs to products or services using activity based costing ORS. de compreher services using activity and contieg - Excel Σ AutoSuri Conditional Format Formaning Table Ce Styles Insert Delete Format Sort & Find & ed $710.000 in total overhead cost to four...

  • fill in the yellow shaded area with the formulas only. All answers must be entered as...

    fill in the yellow shaded area with the formulas only. All answers must be entered as a formula. Click OK to begin. OK ? - х High-Low Method Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign in Calibri 11 % Paste BIU Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styres Cpboard Font Al v Jay Corporation has decided to prepare contribution income statements for A B с D...

  • Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional...

    Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools: materials handling and setup. The collected data follow Number of machine hours Number of material moves Number of setups Standard ModelDeluxe Model 30,800 890 540 25,800 590 70 Total estimated overhead costs are $347,100, of...

  • Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional...

    Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools: materials handling and setup. The collected data follow. Number of machine hours Number of material moves Number of setups Standard Model 25,000 550 80 Deluxe Model 30,000 850 500 Total estimated overhead costs are $303,560,...

  • Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional...

    Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools: materials handling and setup. The collected data follow: Number of machine hours Number of material moves Number of setups Standard Model Deluxe Model 27,000 32,000 650 950 120 600 Total estimated overhead costs are $394,160,...

  • Jullo produces two types of calculator, standard and deluxe. The company is currently using a traditional...

    Jullo produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has Identified two cost pools: materials handling and setup. The collected data follow: Number of machine hours Number of material moves Number of setups Standard Model 25,7ee 585 85 Deluxe Model 30,7ee 885 535 Total estimated overhead costs are $362,930,...

  • Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional...

    Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools: materials handling and setup. The collected data follow: Standard Model Deluxe Model Number of machine hours 26,600 31,600 Number of material moves 630 930 Number of setups 100 580 Total estimated overhead costs are $406,120,...

  • Pre-Built Problems a Julio produces two types of calculator, standard and deluxe. The company is currently...

    Pre-Built Problems a Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools: materials handling and setup. The collected data follow Number of machine hours Number of material moves Number of setups Total estimated overhead costs are $368.360, of which $189.800 is assigned to the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT