Convert the accompanying database to an Excel table to find:a.The total cost of all orders.b. The total quantity of airframe fasteners purchased.c. The total cost of all orders placed with Manley Valve. SupplierHulkey FastenersAlum SheetingManley ValveFast-Tie AerospaceFast-Tie AerospaceSteelpin Inc.Fast-Tie AerospaceManley ValveSteelpin Inc.Durrable ProductsFast-Tie AerospaceFast-Tie AerospaceSteelpin Inc.Hulkey FastenersManley ValveHulkey FastenersSteelpin Inc.Steelpin Inc.Alum SheetingHulkey FastenersSteelpin Inc.Steelpin Inc.Manley ValveHulkey FastenersItem DescriptionAirframe fastenersAirframe fastenersHatch DecalShielded Cable/ft.Shielded Cable/ft.Shielded Cable/ft.Shielded Cable/ft.Machined ValveBolt-nut packagePressure GaugeO-RingShielded Cable/ft.Shielded Cable/ft.Electrical ConnectorPressure GaugeHatch DecalElectrical ConnectorBolt-nut packageControl PanelElectrical ConnectorElectrical ConnectorBolt-nut packageO-RingAirframe fastenersItem Cost$4.25$3.75$1.10$1.05$1.05$1.10$1.05$655.50$3.75$80.00$2.45$1.05$1.00$1.25$100.50$0.75$1.65$3.75$255.00$1.25$1.65$3.75$2.85$4.25Quantity Cost per order19,50012,00057023,00022,50017,50022,5001254,25010018,4005,60070700$82,875.00$45,000.001,30022,500 $23,625.00$18,400.00$7,000.00$7,035.00$525.00$7,425.00$15,750.00$180,030.00$6,875.00$8,002.50$15,562.50$3,990.00$78,625.004,5004,2007065,5004,8504,150140018,500$627.00$24,150.00$23,625.00$19,250.00$23,625.00$81,937.50$15,937.50$8,000.00$3,185.00

Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve.

Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter11: Differential Analysis And Product Pricing

Section: Chapter Questions

Problem 3DQ: A chemical company has a commodity-grade and premium-grade product. Why might the company elect to...

See similar textbooks

Similar questions

Factory security and assembly activities at an appliance manufacturing plant would be best classified as unit-level, batch-level, product-level, or organization-sustaining activities? Option Security Assembly A Product Unit B Batch Batch C Organization Unit D Organization Product Multiple Choice Option A Option B Option C Option D
JCL Inc. is a major chip manufacturing firm that sells its products to computer manufacturers like Dell, Gateway, and others. In simplified terms, chip making at JCL Inc. involves three basic operations: depositing, patterning, and etching. • Depositing: Using chemical vapor deposition (CVD) technology, an insulating material is deposited on the wafer surface, forming a thin layer of solid material on the chip. • Patterning: Photolithography projects a microscopic circuit pattern on the wafer surface, which has a light-sensitive chemical like the emulsion on photographic film. It is repeated many times as each layer of the chip is built. • Etching: Etching removes selected material from the chip surface to create the device structures. Table 7.4 lists the required processing times and setup times at each of the steps. There is unlimited space for buffer inventory between these steps. Assume that the unit of production is a wafer, from which individual chips are cut at a later stage.a.…
discuss the Indirect cost of Samsung products in terms ofi.overhead cost ( electricity)ii.Quality control cost iii.insurance
The cost of solder used in assembling the radios * O Product Cost Period Cost
Classify the above costs of Santana Corporation into activity cost pools using the following: engineering, machinery, machine setup, quality control, factory utilities, maintenance. Budgeted Costs Activity Cost Pool Machine setup, indirect materials Inspections Tests Insurance, plant Engineering design Depreciation, machinery Machine setup, indirect labor Property taxes Oil, heating Electricity, plant lighting Engineering prototypes Depreciation, plant Electricity, machinery Machine maintenance wages
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
Complete all requirements <><>
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
Ramapo Company produces two products, Blinks and Dinks. They are manufactured in two departments, Fabrication and Assembly. Data for the products and departments are listed below.
A manufacturing company, Mani Co, has two divisions: Division EX and Division YX. Both divisions make a single standardised product. Division EX makes component TEX, which is supplied to both Division YX and external customers. Division YX makes product YAS using one unit of component TEX and other materials. It then sells the completed product YAS to external customers. To date, Division YX has always bought component TEX from Division EX. The following information is available: Division EX Division YX $ $ Selling price 40 96 Direct materials: Component TEX (40) Direct materials (12) (17) Direct labour (6) (9) Variable overheads (2) (3) Selling and distribution costs (4) (1) Contribution per unit before fixed costs 16 26 Annual fixed costs $500,000 $200,000 Annual external demand (units) 160,000 120,000 Capacity of plant 300,000 130,000 Division EX charges the same price for…
Lifecycle Costs (LCC) estimates for design, test, production, operations for manufacturing an electric bus Clarify cost responsibilities of the controller, management, and teams for manufacturing an electric bus
Way Cool produces two different models of air conditioners. The company produces the mechanical systems in its components department. The mechanical systems are combined with the housing assembly In Its finishing department. The activities, costs, and drivers associated with these two manufacturing processes and the production support process follow. Process Activity Components Changeover Machining Setups Finishing Welding Support Inspecting Rework Purchasing Providing space Providing utilities Units produced Welding hours Batches Number of inspections Machine hours Setups Rework orders Purchase orders Required 1 Overhead Cost $ 559,650 411,510 74,000 $1,045,160 $ 288,640 257,600 55,000 601,240 $ $ 194,540 30,800 37,960 $ 263,300 Additional production Information concerning its two product lines follows. Required 2 Model 145 1,200 1,200 455 475 3,350 20 150 365 Driver Number of batches Machine hours Number of setups Required 3 Welding hours Number of inspections Rework orders Purchase…