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

Chapter13: Lean Manufacturing And Activity Analysis

Section: Chapter Questions

Problem 21E

See similar textbooks

Related questions

Q: A report that lists the types and amounts of costs incurred in manufacturing is a:

A: A report that lists the types and amounts of cost incurred in manufacturing is a: Schedule of cost…

Q: Match each of the following cost items with the value chain business function where you would expect…

A: Value chain The various business operations and procedures involved in producing a good or providing…

Q: Which of the following descriptions is notcorrect?a. The routing sheet shows the manufacturingpath…

A: Production cost comprises of total costs that are incurred in the process of bringing a product to…

Q: In each blank next to the following types of indirect expenses and service department expenses,…

A: There are some indirect expenses and service department expenses, for which we have to identify best…

Q: Give the journal entry for raw materials purchased on account. Explain how this transaction affects…

A: Raw materials inventory: Raw material inventories are the primary materials which are used in the…

Q: A production cost report contains which of the followingparts? (Identify all correct answers.)a.…

A: Production Cost Report: A report which gives information about the total units produced and total…

Q: Use T-accounts to showthe flow of costs in ajob-order costing system.

A: Every industry maintains different inventory accounts and every industry can use job order costing.…

Q: Which of the following statements regarding process costing are true? 1. When computing the cost per…

A: Process costing is a method of cost apportionment and allocation based solely on the process and is…

Q: 2. Matching Activity with Cost Drivers For each cost pool below, identify an appropriate cost…

A: A cost driver is a factor that determines or influences the cost of an activity or process. It is a…

Q: Baden Company has gathered the following information. Units in beginning work in process 0 Units…

A: Equivalent units of productions material conversion cost 37000 units 65600 units Unit…

Q: Daosta Inc. uses the FIFO method in its process costing system. The following data concern the…

A: Hi studentSince there are multiple subparts asked, we will answer only first three subparts.The…

Q: A cost driver is used to allocate support department expenses. Match each of the following cost…

A: Cost drivers are the base for allocating the cost to various activities. For example, the Cost…

Q: Classify the performance measures below into the most likely balanced scorecard perspective…

Question

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.

Supplier
Hulkey Fasteners
Alum Sheeting
Manley Valve
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Fast-Tie Aerospace
Manley Valve
Steelpin Inc.
Durrable Products
Fast-Tie Aerospace
Fast-Tie Aerospace
Steelpin Inc.
Hulkey Fasteners
Manley Valve
Hulkey Fasteners
Steelpin Inc.
Steelpin Inc.
Alum Sheeting
Hulkey Fasteners
Steelpin Inc.
Steelpin Inc.
Manley Valve
Hulkey Fasteners
Item Description
Airframe fasteners
Airframe fasteners
Hatch Decal
Shielded Cable/ft.
Shielded Cable/ft.
Shielded Cable/ft.
Shielded Cable/ft.
Machined Valve
Bolt-nut package
Pressure Gauge
O-Ring
Shielded Cable/ft.
Shielded Cable/ft.
Electrical Connector
Pressure Gauge
Hatch Decal
Electrical Connector
Bolt-nut package
Control Panel
Electrical Connector
Electrical Connector
Bolt-nut package
O-Ring
Airframe fasteners
Item 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.25
Quantity Cost per order
19,500
12,000
570
23,000
22,500
17,500
22,500
125
4,250
100
18,400
5,600
70
700
$82,875.00
$45,000.00
1,300
22,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.00
4,500
4,200
706
5,500
4,850
4,150
1400
18,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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

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
Define value chain and classification of costs for “Cost of cartridges from outside supplier to be used with Dell printers.”
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.…
How much of the total material handling cost should be allocated to the specialty windows?
Transfer pricing, utilization of capacity. (J. Patell, adapted) Sierra Inc. consists of a semiconductor division and a processcontrol division, each of which operates as an independent prot center. The semiconductor division employs craftsmen who produce two different electronic components: the new highperformance Xcel-chip and an older product called the Dcel-chip. These products have the following cost characteristics:
discuss the Indirect cost of Samsung products in terms ofi.overhead cost ( electricity)ii.Quality control cost iii.insurance
Key Performance Indicators of automibile manufacturing company
The cost of printed circuit boards used in the radios * O Product Cost O Period Cost
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
Store Corporation is in the process of scheduling the appropriate machinery to switch their production to a new product line, this is an example of a(n):
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