Question

4 1 Sundial Co, has assigned $710.000 in total overhead cost to four different activity cost pools. The activity requirements
Overhead Assigned Using Activity Proportions (5) Overhead Assigned Using Activity Rates 14 Verification Create thee statement

can you please show me the formula you use for each yellow highlighted?
how do you enter it on excel?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

40 41 Activity Cost Pool Material Handling Machine Set-Ups Engineering Support Power and Space Total Overhead Cost Overhead C

Overheads Assigned using Activity Rates Economy Deluxe Overheads Assigned using Activity Proportion(%) Economy Deluxe Total V

Add a comment
Know the answer?
Add Answer to:
can you please show me the formula you use for each yellow highlighted? how do you...
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
  • fill in the yellow shaded area with formulas only! All answers must be entered as a...

    fill in the yellow shaded area with formulas only! 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 services using activity based costing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Be Wrap Text General WE Paste BIU- Merge & Center - Insert Delete Format $ . %8....

  • 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...

  • 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...

  • Could you please help me to solve this exercise. I m very grateful if you can...

    Could you please help me to solve this exercise. I m very grateful if you can do it in details with so that i can understand how numbers come from. Many many thanks. Anna. HiTech Products manufactures three types of DVD player, Economy, Standard and Deluxe. The Co. which uses activity- based costing, has identified five activities. Each activity, its budgeted cost and related cost driver is identified below: Activity Cost Cost Drivers Material handling $225,000 No. of parts Material...

  • I'm confused on how to solve this and would appreciate the help Fontillas Instrument, Inc. manufactures...

    I'm confused on how to solve this and would appreciate the help Fontillas Instrument, Inc. manufactures twa praducts: missile range instruments and space pressure gauges. During April, it produced 50 range instruments and 200 pressure gauges and incurred estimated overhead costs of $94,220. An analysis of estimated overhead costs reveals the follawing activities: Activities Total Cost Cost Drivers 1. Materlal handling Number of requisitions $34,980 2. Machine set-ups Number of set-ups 28,420 Number of inspections 3. Quality inspections 30,820 $94,220...

  • The accountant for Snappy Photograph Enterprise (SPE) has estimated the following activity cost pools and activity...

    The accountant for Snappy Photograph Enterprise (SPE) has estimated the following activity cost pools and activity drivers for the coming year: Activity Budgeted overhead Activity driver Activity level cost (RM) Machine set ups 300,000 No. of set ups 100 set ups Material handling 150,000 Weight of raw 50,000 kg material Hazardous waste 75,000 Weight of hazardous 10,000 kg control chemicals used Quality control No. of inspection 1,000 inspections Other overhead cost 300,000 Machine hours 20,000 hours Total 937,000 112,500 An...

  • can someone please do the total and the production for both of them Xie Company identified...

    can someone please do the total and the production for both of them Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures two types of go-karts: Deluxe and Basic. 0.85 points Activity Handling materials Inspecting product Processing purchase orders Paying suppliers Insuring the factory Designing packaging Expected Costs $625,000 900,000 105,000 175,000 300,000 75,000 Expected Activity 100,000 parts 1,500 batches 700 orders 500 invoices 40,000 square feet 2 models 8 00:38:03 eBook Assume...

  • Could anyone help me please? Thank You!! Bluefield has decided to use an ABC costing system...

    Could anyone help me please? Thank You!! Bluefield has decided to use an ABC costing system and has identified the following detailed information about its cost pools and cost drivers: Activity cost pools Materials handling Machine maintenance $65,280 $8,580 Cost drivers Number of material moves Number of machine hours 510 39,000 Required: 1. Calculate Bluefield's activity rate for each cost pool. 2. Determine the amount of overhead assigned to Bluefield's products if each has the following activity demands: Product A...

  • Willow Company produces lawn mowers. One of its plants produces two versions of mowers: a basic...

    Willow Company produces lawn mowers. One of its plants produces two versions of mowers: a basic model and a deluxe model. The deluxe model has a sturdier frame, a higher horsepower engine, a wider blade, and mulching capability. At the beginning of the year, the following data were prepared for this plant: Basic Model Deluxe Model Expected quantity 40,000 20,000 Selling price $180 $360 Prime costs $80 $160 Machine hours 5,000 5,000 Direct labor hours 10,000 10,000 Engineering support (hours)...

  • Schell Company manufactures automobile floor mats. It currently has two product lines, the Standard and the...

    Schell Company manufactures automobile floor mats. It currently has two product lines, the Standard and the Deluxe. Suppose that Schell has conducted further research into its overhead and potential cost drivers. As a result, the company has compiled the following detailed information, breaking total overhead into three cost pools: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Standard Floor Mat Line Quantity/Amount Consumed by Deluxe Floor Mat Line Material handling Number of moves $ 1,564.00 33...

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