Montrose Instrumentation produces measurement equipment. One component, used in a variety of the company's products, is critical and the supply chain often breaks. For that reason, Montrose has a policy to hold in inventory enough of the component to produce three month's worth of sales (one component is used in each unit of product in which it is used). On February 1, the company has 31,000 components in stock. Sales of the units in which the component is used in each of the next six months are estimated to be as follows: February 32,500 March 26,500 April 28,000 May 33,550 June 30,150 July 42,110

Montrose Instrumentation produces measurement equipment. One component, used in a variety of the company's products, is critical and the supply chain often breaks. For that reason, Montrose has a policy to hold in inventory enough of the component to produce three month's worth of sales (one component is used in each unit of product in which it is used). On February 1, the company has 31,000 components in stock. Sales of the units in which the component is used in each of the next six months are estimated to be as follows: February 32,500 March 26,500 April 28,000 May 33,550 June 30,150 July 42,110

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterC: Cases

Section: Chapter Questions

Problem 1C

See similar textbooks

February	32,500
March	26,500
April	28,000
May	33,550
June	30,150
July	42,110

Required:

Estimate purchases of the component (in units) for February and March.
Estimate the cash disbursements for the component in February and March.

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

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Montrose Instrumentation produces measurement equipment. One component, used in a variety of the company's products, is critical and the supply chain often breaks. For that reason, Montrose has a policy to hold in inventory enough of the component to produce three month's worth of sales (one component is used in each unit of product in which it is used). On February 1, the company has 40,000 components in stock. Sales of the units in which the component is used in each of the next six months are estimated to be as follows: February March April May June July 34,750 28,750 30,250 35,800 32,400 44,360 Parts are purchased at a wholesale price of $55. The vendor has a financing arrangement by which Montrose pays 40 percent of the purchase price in the month when the components are delivered and 60 percent in the following month. Montrose purchased 42,500 parts in January. Required: a. Estimate purchases of the component (in units) for February and March. b. Estimate the cash disbursements…
Montrose Instrumentation produces measurement equipment. One component, used in a variety of the company's products, is critical and the supply chain often breaks. For that reason, Montrose has a policy to hold in inventory enough of the component to produce three month's worth of sales (one component is used in each unit of product in which it is used). On February 1, the company has 31,000 components in stock. Sales of the units in which the component is used in each of the next six months are estimated to be as follows: February March 32,500 26,500 April May 28,000 33,550 June July 30,150 42,110 Parts are purchased at a wholesale price of $46. The vendor has a financing arrangement by which Montrose pays 40 percent of the purchase price in the month when the components are delivered and 60 percent in the following month. Montrose purchased 38,000 parts in January. Required: a. Estimate purchases of the component (in units) for February and March. b. Estimate the cash disbursements…
Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts manager is currently revising the inventory policy for XL-20, one of the chemicals used in the production process. The chemical is purchased in 10-pound canisters for $95 each. The firm uses 4,800 canisters per year. The controller estimates that it costs $150 to place and receive a typical order of XL-20. The annual cost of storing XL-20 is $4 per canister. Required: 1. Prepare a table showing the total annual cost of ordering and storing XL-20 for each of the follow- ing order quantities: 400, 600, and 800 canisters. 2. What are the weaknesses in the tabular approach?
Paramount Limited is reviewing the purchasing policy for one of its raw materials due to a reduction in production requirements. The material used evenly throughout the year is used for the company's products, the production of which is currently 285,000 units annually. Each finished unit of the product contains 0.4 kg of this material. 5% of the material is expected to be lost in the production processes. Purchases are usually made through Letters of Credits and can be made in multiples of 1,000 kg, with a minimum purchase order quantity of 1,000 kg. The cost of this raw material depends upon the purchase order quantity as follows: Order quantity (kg) Cost per kilogram ($) 1,000 2,000 3,000 4,000 6,000 12,000 10.00 9.80 9.65 9.50 9.35 9.20 The costs of placing and handling each order are $1,200, of which $300 is an apportionment of this cost which is not expected to be affected in the short term by the number of orders placed. The annual storage cost of stock is $20 per unit, of which…
Cambridge Company manufactures plastic bottles that it sells to organizations that manufacture bottled water. During the most recent month, there was no opening inventory. During the month, 25 million bottles were entered into production and 24 million were completed The units in ending inventory were 100% complete with respect to materials costs and 60% complete with respect to conversion costs. During the month, materials costs were $500,000 and conversion costs were $246,000. Do not round intermediate calculations. a) What was the number of equivalent units work done for conversion costs this month? 24,600,000 b) What was the cost per equivalent unit of conversion cost this month? Round answer to three decimal places. $ 0.01 c) What is the cost that will be allocated to units completed and transferred out? Round answer to nearest whole dollar amount. $ 240,000 d) What is the cost that will be allocated to ending work in process? Round answer to nearest whole dollar amount. $ 6,000 X
Elijah Electronics makes wireless headphone sets. The firm produced 58,500 wireless headphone sets during its first year of operation. At year-end, it had no inventory of finished goods. Elijah sold 54,990 units through regular market channels, but 585 of the units produced were so defective that they had to be sold as scrap. The remaining units were reworked and sold as seconds. For the year, the firm spent $312,000 on prevention costs and $156,000 on quality appraisal. There were no customer returns. An income statement for the year follows. (See attached) a. Compute the total pre-tax profit lost by the company in its first year of operations by selling defective units as seconds or as scrap rather than selling the units through regular channels. $______ b. Compute the total failure cost for the company in its first year. $______ c. Compute total quality cost incurred by the company in its first year. $______
Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 230 units at $45 per unit. During the year, Cortez made two batch purchases of this chair. The first was a 265-unit purchase at $50 per unit; the second was a 360-unit purchase at $52 per unit. During the period, it sold 535 chairs. RequiredDetermine the amount of product costs that would be allocated to cost of goods sold and ending inventory, assuming that Cortez uses FIFO. LIFO. Weighted average.
Jim Overstreet, inventory control manager for Itex, receives wheel bearings from Wheel-Rite, a small producer of metal parts. Unfortunately, Wheel-Rite can produce only 500 wheel bearings per day. Itex receives 10,000 wheel bearings from Wheel-Rite each year. Since Itex operates 200 working days each year, its average daily demand for wheel bearings is 50. The ordering cost for Itex is $40 per order, and the carrying cost is 60 cents per wheel bearing per year. How many wheel bearings should Itex order from Wheel-Rite at one time? Wheel-Rite has agreed to ship the maximum number of wheel bearings that it produces each day to Itex when an order has been received.
Global GPS industries assembles its GPS systems with the following costs. Each or requires one computer system and 4 batteries. Computer systems cost $140 each, and Batteries are $2.50 each. Global is able to reliably obtain computers as needed and does not maintain them in inventory. However, batteries are stocked in inventory sufficient to produce 20% of the following month's expected production. Planned production is as follows: January February March April 24,000 systems 39,750 systems 23,850 systems 25,000 systems BB batter Compute No end/No Required: Prepare a direct material purchasing plan for January, February, and March based on the above facts.
Please show supporting calculations. During a recent accounting period, ABC Co.'s shipping department processed 26 orders. Each order typically takes four hours to complete; however, the average time increased to five hours because of various departmental inefficiencies. If shipping labor is paid P14 per hour, the company's non-value-added cost would be Your answer Inspection time for a plant is 10,000 hours per year. The cost of inspection consists of salaries of four inspectors, totaling P60,000. Inspection also used supplies costing P3 per inspection hour. The company has a close to zero defect state and has eliminated the need for any inspection activity. Calculate the nonvalue-added cost of inspection per year. Your answer
Elijah Electronics makes wireless headphone sets. The firm produced 27,000 wireless headphone sets during its first year of operation. At year-end, it had no inventory of finished goods. Elijah sold 25,380 units through regular market channels, but 270 of the units produced were so defective that they had to be sold as scrap. The remaining units were reworked and sold as seconds. For the year, the firm spent $144,000 on prevention costs and $72,000 on quality appraisal. There were no customer returns. An income statement for the year follows. Sales Regular channel $5,076,000 Seconds 128,250 Scrap 9,450 $5,213,700 Cost of goods sold Original production costs $1,725,840 Rework costs 37,800 Quality prevention and appraisal 216,000 $1,979,640 Gross margin $3,234,060 Selling and administrative expenses (all fixed) 882,000 Profit before income taxes $2,352,060 Compute the total pre-tax…
Maron manufactures a single product and has a JIT policy that ending inventory must equal 5% of the next month's sales. It estimates that May's ending inventory will consist of 14,000 units. June and July sales are estimated to be 280,000 and 290,000 units, respectively. It assigns variable overhead at a rate of 1.80 per unit of production. Fixed overhead equals 400,000 per month. Compute the number of units to be produced and use this amount to compute the total budgeted overhead that would appear on the factory overhead budget for the month of June. Multiple Choice • 922,000 • 904,900 • 920,200 930,100 878,800