Homework Answers
Solution
| Gross profit | $ 38,800.00 |
| Net profit | $ 29,200.00 |
Working
| A | Profir per unit | $ 2.00 |
| B | Quantity | 19400 |
| C=A x B | Gross profit | $ 38,800.00 |
| D | Total cost | $ 9,600.00 |
| E=C-D | Net profit | $ 29,200.00 |
Add Answer to:
Wk Qu. 4-14 An analyst is constructing... An analyst is constructing a simple model to determine...
Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with...
Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). TA 1 2 Unit Price 3 Unit Cost 4 Unit Gross Profit 10 5.73 Unit Price - Unit_Cost Quantity Sold 7,500 6 7 8 9 10 11 12 ost Gross Revenue Variable Costs Fixed Costs Net Profit Profit per Unit = Quantity_Sold x Unit Price = Quantity_Sold x...
Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes...
Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes the following data entries. Cell Value B3 88,000 B4 86,000 B5 83,000 B6 L 95,000 Revenue 2 Month 3 January 4 February 5 March 6 April Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Value Cell C4 |
Wk Qu. 4-15 An analyst has started... An analyst has started preparing a spreadsheet as shown...
Wk Qu. 4-15 An analyst has started... An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and column B analysts name to be used in Excel.AB1Price per UnitPrice per Unit2Cost per UnitCost_Per_Unit3Profit per UnitProfit per Unit45Fixed CostsFixed_Costs6Variable CostsVariable_CostsLabel each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range NamePrice per UnitCost_Per_UnitProfit per...
Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to...
Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount. To be complete, the student included a calculation of sales tax in the final price, given the original price (180), discount (0.2), and sales tax rate (0.09) shown below. А 2 Original Price 3 Discount(%) 4 Discount ($) 5 Net Price 6 Sales Tax(%) 7 Sales Tax($) 8 Final Price 180...
Product B Product A Direct materials $14 per unit 0.5 DLH per unit 0.4 MH per...
Product B Product A Direct materials $14 per unit 0.5 DLH per unit 0.4 MH per unit $25 per unit 1.5 DLH per unit 1.1 MH per unit Direct labor hours Machine hours Batches 125 batches 250 batches 10,000 units 10 modifications 2,000 units Volume Engineering modifications Number of customers 50 modifications 500 customers 400 customers 95 per unit per 'unit Market price $35 per unit The company's direct labor rate is $20 per direct labor hour (DLH). Additional information...
Product A Product B Direct materials $ 14 per unit $ 24 per unit Direct labor...
Product A Product B Direct materials $ 14 per unit $ 24 per unit Direct labor hours 0.5 DLH per unit 1.5 DLH per unit Machine hours 0.4 MH per unit 1.1 MH per unit Batches 120 batches 240 batches Volume 10,000 units 2,000 units Engineering modifications 10 modifications 50 modifications Number of customers 500 customers 400 customers Market price $ 36 per unit $ 95 per unit per unit The company's direct labor rate is $20 per direct labor...
please help!! need this done within the next 4 hours please help! Problem 17-1A Comparing costs...
please help!!
need this done within the next 4 hours please help!
Problem 17-1A Comparing costs using ABC with the plantwide overhead rate LO P1, P3, A1, A2 The following data are for the two products produced by Tadros Company Direct materials Direct labor hours Machine hours Batches Volume Engineering modifications Number of customers Market price Product A $15 per unit 0.5 DLH per unit 0.4 MH per unit 90 batches 10,000 units 10 modifications 500 customers $35 per unit...
P4-2A Schultz Electronics manufactures two ultra high-definition television models: the Royale which sells a new model,...
P4-2A Schultz Electronics manufactures two ultra high-definition television models: the Royale which sells a new model, the Majestic, which sells for $1,300. The production cost computed per unit under traditional costing for each model in 2017 as follows Assign overhead to products using ABC and evaluate decision for $1,600 and Traditional Costing Direct materials Direct labor ($20 per hours) Manufacturing overhead ($38 per DLH) Royale $700 120 228 $1,048 Majestic $420 100 190 $710 Total per unit cost In 2017,...
please be as clear and as simple as possible. I am trying to understand it. show...
please be as clear and as
simple as possible. I am trying to understand it. show me the
steps, not only the answers. thank you in advance.
E25-2 Compute standard materials costs Hank Itzek manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. The following are required for production of a 50-gallon batch. 3,000 ounces of grape concentrate at $0.06 per ounce 54 pounds of granulated sugar at $0.30 per pound 60 lemons at...
Question 4: Under the required 2 tab: Determine the total cost per unit for each product...
Question 4:
Under the required 2 tab: Determine the total cost per unit for
each product line if the direct labor and direct materials costs
per unit are $250 for Model 145 and $122 for Model 212. (Round your
final answers to 2 decimal places.)
Under the required 3 tab: If the market price for Model 145 is
$710.99 and the market price for Model 212 is $377.51, determine
the profit or loss per unit for each model. (Round your...
Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). TA 1 2 Unit Price 3 Unit Cost 4 Unit Gross Profit 10 5.73 Unit Price - Unit_Cost Quantity Sold 7,500 6 7 8 9 10 11 12 ost Gross Revenue Variable Costs Fixed Costs Net Profit Profit per Unit = Quantity_Sold x Unit Price = Quantity_Sold x...
Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes the following data entries. Cell Value B3 88,000 B4 86,000 B5 83,000 B6 L 95,000 Revenue 2 Month 3 January 4 February 5 March 6 April Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Value Cell C4 |
Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount. To be complete, the student included a calculation of sales tax in the final price, given the original price (180), discount (0.2), and sales tax rate (0.09) shown below. А 2 Original Price 3 Discount(%) 4 Discount ($) 5 Net Price 6 Sales Tax(%) 7 Sales Tax($) 8 Final Price 180...
Product B Product A Direct materials $14 per unit 0.5 DLH per unit 0.4 MH per unit $25 per unit 1.5 DLH per unit 1.1 MH per unit Direct labor hours Machine hours Batches 125 batches 250 batches 10,000 units 10 modifications 2,000 units Volume Engineering modifications Number of customers 50 modifications 500 customers 400 customers 95 per unit per 'unit Market price $35 per unit The company's direct labor rate is $20 per direct labor hour (DLH). Additional information...
please help!!
need this done within the next 4 hours please help!
Problem 17-1A Comparing costs using ABC with the plantwide overhead rate LO P1, P3, A1, A2 The following data are for the two products produced by Tadros Company Direct materials Direct labor hours Machine hours Batches Volume Engineering modifications Number of customers Market price Product A $15 per unit 0.5 DLH per unit 0.4 MH per unit 90 batches 10,000 units 10 modifications 500 customers $35 per unit...
P4-2A Schultz Electronics manufactures two ultra high-definition television models: the Royale which sells a new model, the Majestic, which sells for $1,300. The production cost computed per unit under traditional costing for each model in 2017 as follows Assign overhead to products using ABC and evaluate decision for $1,600 and Traditional Costing Direct materials Direct labor ($20 per hours) Manufacturing overhead ($38 per DLH) Royale $700 120 228 $1,048 Majestic $420 100 190 $710 Total per unit cost In 2017,...
please be as clear and as
simple as possible. I am trying to understand it. show me the
steps, not only the answers. thank you in advance.
E25-2 Compute standard materials costs Hank Itzek manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. The following are required for production of a 50-gallon batch. 3,000 ounces of grape concentrate at $0.06 per ounce 54 pounds of granulated sugar at $0.30 per pound 60 lemons at...
Question 4:
Under the required 2 tab: Determine the total cost per unit for
each product line if the direct labor and direct materials costs
per unit are $250 for Model 145 and $122 for Model 212. (Round your
final answers to 2 decimal places.)
Under the required 3 tab: If the market price for Model 145 is
$710.99 and the market price for Model 212 is $377.51, determine
the profit or loss per unit for each model. (Round your...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago