(hour) 5.60 5.76 20 3.00 3.04 30 3.80 3.88 35 4.80 5.00 15

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter19: Variable Costing (varcost)
Section: Chapter Questions
Problem 4R: To determine the effect of different levels of production on the company’s income, move to cell B7...
icon
Related questions
Question

please help me to solve this problem 

For a company with the product portfolio in the Table, determine an aggregate unit and determine the material cost, revenue and net production time per
aggregate unit.
Family Material
Revenue/
Percentage Share
Setup
Time/Batch Batch Size
(hour)
Average
Production Net
Cost/ Unit Unit ($)
($)
Time/ Unit Production of Units Sold
Time/Unit
(hour)
5.76
(hour)
A
15
54
8
50
5.60
20
B
7
30
6
150
3.00
3.04
30
3.80
4.80
9
39
8
100
3.88
35
15
12
49
10
50
5.00
Transcribed Image Text:For a company with the product portfolio in the Table, determine an aggregate unit and determine the material cost, revenue and net production time per aggregate unit. Family Material Revenue/ Percentage Share Setup Time/Batch Batch Size (hour) Average Production Net Cost/ Unit Unit ($) ($) Time/ Unit Production of Units Sold Time/Unit (hour) 5.76 (hour) A 15 54 8 50 5.60 20 B 7 30 6 150 3.00 3.04 30 3.80 4.80 9 39 8 100 3.88 35 15 12 49 10 50 5.00
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College