Answered: a) What is the gross margin now? Gross… | bartleby

Excel Applications for Accounting Principles

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 2R

See similar textbooks

Related questions

Question

1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this:
1
2
3 Data
4
Sales
Variable costs:
5
67 00
8
A
Chapter 1: Applying Excel
9
10
11
Cost of goods sold
Variable selling
Variable administrative
Fixed costs:
Fixed selling
Fixed administrative
$
$
$
$
$
$
B
32,000
16,000
1,600
1,400
2,500
1,500

If your formulas are correct, you should get the correct answers to the following questions.
(a) What is the gross margin now?
Gross margin
(b) What is the net operating income now?
Net operating income
(c) What is the contribution margin now?
Contribution margin

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

The following information is given for Gator Company, who uses the FIFO method. Item Quantity Cost NetRealizableValue ReplacementCost NRVMinusNormalProfit 1 1 $17.70 $24.60 $18.00 $17.10 2 1 10.80 8.28 9.30 5.58 3 1 72.00 64.80 67.20 57.60 4 1 4.80 3.12 2.88 2.64 5 1 12.00 12.30 12.60 11.10 6 1 48.00 45.60 38.40 40.80 Required: a. Determine the lower of cost or net realizable value for each inventory item for Gator Company. Item 1 2 3 4 5 6 b. Determine the lower of cost or net realizable value for Gator Company's inventory if the lower of cost or net realizable value rule is applied to the total inventory.$_______
Value chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Business Function Cost Item Answera. Research and development 1. Labor time to repair products under warrantyb. Design 2. TV commercial spotsc. Production 3. Labor costs of fi lling customer ordersd. Marketing 4. Testing of competitor’s producte. Distribution 5. Direct manufacturing labor costsf. Customer service 6. Development of order tracking system forthe Internet7. Printing cost of new product brochures8. Hours spent designing childproof bottles9. Training costs for representatives to staff the customer call center10. Installation of robotics equipment in manufacturing plant
E15-19. Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order Processing Costs 1 3,300 $90,970 2 1,650 55,412 3 4,840 132,770 4 3,080 90,090 5 2,530 76,752 6 1,320 47,410 7 2,200 68,750 Required a. Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. b. Plot the data on a scatter diagram. Using the information from representative high- and low-volume months, develop a cost-estimating equation for monthly production costs. c. What factors might have caused the difference in the equations developed for requirements (a) and (b)?
2. Calculate the relative distribution percentages for each quality cost category. Round percentages to one decimal place if rounding is required. For example, 5.789% would be entered as "5.8". Prevention fill in the blank f53288f73071ff5_1 % Appraisal fill in the blank f53288f73071ff5_2 % Internal failure fill in the blank f53288f73071ff5_3 % External failure fill in the blank f53288f73071ff5_4 % Comment on the distribution. Quality Cost Report, Taguchi Loss Function Kathy Shorts, president of Oliver Company, was concerned with the trend in sales and profitability. The company had been losing customers at an alarming rate. Furthermore, the company was barely breaking even. Investigation revealed that poor quality was at the root of the problem. At the end of 20x5, Kathy decided to begin a quality improvement program. As a first step, she identified the following costs in the accounting records as quality related: 20x5 Sales (644,000 units @ $100) $64,400,000…
Info in images Required: 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) B300 T500 Total Product margin $0 2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.) B300 T500 Total Product margin $0 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…
Please show your computations using good accounting form through excel. Thank you! Problem: By products In Department III of SAMCIS Company, a portion of the materials (a by-product) is removed further processed and sold. The Company uses the reversal cost method to account for the by-product. Data for June include: Amount of by-product removed is 2,000 units; Estimated sales price of by-product after processing further is P1.20/unit. Estimated processing cost after separation is P0.30 per unit and estimated selling expenses is 10% of the sales price. The estimated profit margin is 5% of the sales price. What is the gain (loss) on sale of the by-product if all of the units are sold at P1.50?
Please show your computations using good accounting form through excel. Thank you! Problem: By products In Department III of SAMCIS Company, a portion of the materials (a by-product) is removed further processed and sold. The Company uses the reversal cost method to account for the by-product. Data for June include: Amount of by-product removed is 2000 units; Estimated sales price of by-product after processing further is P1.20/unit. Estimated processing cost after separation is P0.30 per unit and estimated selling expenses is 10% of the sales price. The estimated profit margin is 5% of the sales price. What is the total cost of the by-product?
Value chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Business Function Cost Item Answera. Research and development 1. Purchase of raw materialsb. Design 2. Advertisingc. Production 3. Salary of research scientistsd. Marketing 4. Shipping expensese. Distribution 5. Reengineering of product assembly processf. Customer service 6. Replacement parts for warranty repairs7. Manufacturing supplies8. Sales commissions9. Purchase of CAD (computer-aideddesign) software10. Salary of website designer
Account Activity and Relationships Each case is independent. Solve for missing data in alphabetical order. (Hint: Refer to Exhibit 18.6, p. 18-17 and the WIP table, p. 18-25.) Case A Case B Case C Case D Sales $425,000 Answer 550,000 Answer Direct materials 75,000 105,000 Answer 105,000 Direct labor 25,000 Answer 100,000 Answer Total direct costs Answer 160,000 Answer 150,000 Conversion cost Answer 130,000 Answer Answer Manufacturing overhead 40,000 Answer 50,000 Answer Current manufacturing costs Answer Answer 475,000 395,000 Work in process, beginning 35,000 50,000 Answer 105,000 Work in process, ending 25,000 Answer 105,000 Answer Cost of goods manufactured Answer 160,000 Answer 410,000 Finished goods inventory, beginning 45,000 40,000 35,000 60,000 Finished goods inventory, ending 30,000 Answer 40,000 Answer Cost of goods sold Answer 175,000 Answer 400,000 Gross profit…
** Please don't use hand writing and don't copy and paste *** I want new and unique answer .. Thank you ACT 301 Q2. RCR has two support departments, X1 and X2, and two operating departments, Z1 and Z2. RCR has decided to use the direct method and allocate variable X1 dept. costs based on the number of transactions and fixed X1 dept. costs based on the number of employees. X2 dept. variable costs will be allocated based on the number of service requests and fixed costs will be allocated based on the number of computers. The following information is provided: Support Departments Operating Departments X1 X2 Z1 Z2 Total Department variable costs 12,500 15,000 95,000 52,500 Total department fixed costs 14,500 27,500 105,000 45,000 Number of transactions 38 45 175 112 Number of employees 14 18 38 30 Number of service requests 30 18 38 25 Number of computers 15 20 25 30 You are…
Answer the following 2 questions based on the information in the spreadsheet you created below: Year 1 Year 2 Year 3 Year 4 $ % $ % $ % $ % Net Sales $ 500,000.00 100.00% $ 540,000.00 100.00% $ 577,800.00 100.00% $ 612,468.00 100.00% Cost of goods 265,000.00 53.00% $ 283,500.00 52.50% $ 300,456.00 52.00% $ 321,545.70 52.50% Gross Margin 235,000.00 47.00% $ 256,500.00 47.50% $ 277,344.00 48.00% $ 290,922.30 47.50% Operating expenses 210,000.00 42.00% $ 226,800.00 42.00% $ 245,565.00 42.50% $ 257,236.56 42.00% Operating proft 25,000.00 5.00% $ 29,700.00 5.50% $ 31,779.00 5.50% $ 33,685.74 5.50% 1. What can Mr. Ptolemy do to achieve the gross margin percentage goal set for the third and fourth years? Hint: What factors and elements of a P & L statement affect gross margin %?(List at least 2 things) 2. What efforts should Mr. Ptolemy make in the third and…
choose the best answer (mcqs) just choose the no need of any explanation: 1) The following information is available for Barnes Company for the fiscal year ended December 31: Beginning finished goods inventory in units 0 Units produced 4,800 Units sold 4,000 Sales $ 400,000 Materials cost $ 96,000 Variable conversion cost used $ 48,000 Fixed manufacturing cost $ 72,000 Indirect operating costs (fixed) $ 80,000 The variable costing operating income is: A $120,000 B $104,000 C $140,000 D $128,000 2) Lupo Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on machine-hours. The company based its predetermined overhead rate for the current year on the following data: Total machine-hours 30,000 Total fixed manufacturing overhead cost $ 252,000 Variable manufacturing overhead per machine-hour $ 2.10 Recently, Job T687 was completed with the…

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

Quickbooks Online Accounting

Quickbooks Online Accounting

Accounting

ISBN:

9780357391693

Author:

Owen

Publisher:

Cengage

Excel Applications for Accounting Principles

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Quickbooks Online Accounting

Quickbooks Online Accounting

Accounting

ISBN:

9780357391693

Author:

Owen

Publisher:

Cengage

SEE MORE TEXTBOOKS