Using Excel to Cost Inventory PROBLEM In its first month of operations, McLanie Company made three purchases. Information concerning these purchases and units on hand are: Units 300 400 500 Cost per Unit $6.00 8.00 9.00 Units on hand at period en Purchases of merchandise were made in the sequence listed above. 200 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory. Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. Weighted-average unit cost Round unit cost to 3 decimals using the ROUND function Cost of ending inventory

Q: Materials used by the Instrument Division of Ziegler Inc. are currently purchased from outside…

A: Operating income is the amount of money earned by the entity after deducting the operating expenses…

Q: Anderson Candy Company budgeted the following costs for anticipated production for October: Line…

A: Variable cost is the cost that changes with change in the activity of cost driver used. The variable…

Q: Beginning inventory, purchases, and sales data for tennis rackets are as follows: April 3 Inventory…

A: Under the FIFO method, the oldest products in inventory are sold first.

Q: On December 31, 2024, Sunland Company leased machinery from Carla Vista Corporation for an…

A: Lease is defined a contractual agreement incorporated between two business entities where one entity…

Q: On August 1 of year O, Dirksen purchased a machine for $38,250 to use in its business. On December 4…

A: Depreciation seems to be one of the accounting approaches used to spread the worth of tangible fixed…

Q: Lavage Rapide owns and operates a large automatic car wash facility near Montreal. The following…

A: FLEXIBLE BUDGETA flexible budget is a budget that is prepared for different levels of activity or…

Q: Selling Price Variable manufacturing cost Fixed manufacturing cost Variable selling & administrative…

A: In order to evaluate a project, product, or service's financial viability and to make well-informed…

Q: Department G had 1,920 units 25% completed at the beginning of the period, 12,500 units were…

A: The ending inventory under FIFO (first-in-first-out) is normally from the introduced units if all of…

Q: Target Costing Laser Impressions Inc. manufactures color laser printers. Model J20 presently sells…

A: In order to ascertain the intended cost of a product based on market conditions and customer…

Q: Delta Machine Company purchased a computerized assembly machine for $108.000 on January 1. Year 1…

A: Depreciation expense :— It is the allocation of depreciable cost of asset over the estimated useful…

Q: Alcoser Corporation's most recent balance sheet appears below: Comparative Balance Sheet Assets:…

A: Cash flow statement :— It is one of the financial statements that shows change in cash and cash…

Q: Burwell Manufacturing is organized into two divisions (Agriculture and Mining) and a corporate…

A: Overhead distribution worksheet is the apportionment of indirect cost to different departments based…

Q: Exercise 19-18 (Static) Analyzing a special offer for a service company LO P3 Empire Airlines…

A: Income statement is a financial statement that shows profitability, total revenue and total…

Q: Using the same purchase information at the beginning of the question, prepare the table assuming…

A: Depreciation expense :— It is the allocation of depreciable cost of asset over the estimated useful…

Q: Myriad Solutions, Inc. issued 10% bonds, dated January 1, with a face amount of $500 million on…

A: An essential tool for managing your business are financial statements. They provide vital…

Q: ! Required information LeMay Department Store uses the retail inventory method to estimate ending…

A: Particulars                       cost         retailBeginning inventory     $43000…

Q: Current Attempt in Progress In fiscal 2023, Sarasota Realty Corporation purchased unimproved land…

A: Sales revenue means amount earned on account of sales of goods and services. Cost of goods sold is…

Q: ng Tool is a machine shop that uses job order costing. Overhead is applied to individual jobs at a…

A: A journal entry is a basic accounting record that is used to chronologically track financial…

Q: Required information [The following information applies to the questions displayed below.] Wyalusing…

A: Return on investment (ROI) is one of the profitability ratio being used in business for determining…

Q: Handy Home sells windows (80% of sales) and doors (20% of sales). The selling price of each window…

A: The break-even point is reached when the revenue from sales exactly matches the total production and…

Q: On July 8, Azure Corporation enters into an agreement with one of its customers, Madsen, Inc. to…

A: Unearned revenue is recorded as a current liability on the balance sheet date. This is created when…

Q: chriever Corporation is an oil well service company that measures its output by the number of wells…

A: The main purpose of Standard costing is to compare your actual performance with these standards and…

Q: The following is a list of inventory items for Ducard Company on April 30. Item Quantity Unit Cost…

A: Inventory is a current asset that is sold to make a profit. The inventory is generally presented at…

Q: Buffalo Co compensates its executives with stock options. On January 1, 2021, it granted its…

A: Expense for stock option will be booked over a period of 5 years, as the options will vest over a…

Q: The accountant has started the PPE and Depreciation Schedule for the year ended September 30, 2023.…

A: Depreciation Expenses:Depreciation expense is the of  the portion of a company's tangible asset cost…

Q: On January 1,2017. Crane Company had a balance of $382,000 of goodwill on its balance sheet that…

A: Journal Entry :— It is an act of recording transactions in books of account when transaction…

Q: Use the following information for the Problems below: The following data pertain to three divisions…

A: ROI means return on investment.. It is the percentage return earned by the entity on the operating…

Q: Question Content Area Gull Corp. is considering selling its old popcorn machine and replacing it…

A: Under differential analysis we should compare profit (loss) from one option with another option and…

Q: Sheridan Inc., reported the following information about two of its machines as at December 31, 2023.…

A: The Depreciation expense is charged on fixed assets as reduction in the value of the fixed assets…

Q: Show the entry to be made by Cooley Grocery Store for the March 25 cash register reading showing…

A: Unearned revenue represents the liability because these are the advance payments made by the…

Q: Buring 2020, Organic Foods Inc. made sales of $4.000 (assume all on account) and collected cash of…

A: A company's income statement offers insightful information about its financial performance,…

Q: Exercise 16-38 (Algo) Flexible Budget (LO 16-2) Golden Food Products produces special-formula pet…

A: A flexible budget is one that can change depending on the activity or volume levels of a business. A…

Q: Belle Corporation owns as an investment 10% of the stock of Ton Corporation, with an adjusted basis…

A: Gain/(Loss) = Fair market value of the property distributed - Adjusted basis of Property…

Q: Sell or Process Further Abica Coffee Company produces Columbian coffee in batches of 6,300 pounds.…

A: Sell Or Process Further Means Management Can Use Differential Analysis To Decide Whether To Process…

Q: d inflows of resources-unavailable revenu

A: Deferred Inflows of Resources - Unavailable Revenues are reported in a government general fund…

Q: The following interest-bearing promissory note was discounted at a bank by the payee before…

A: Promissory note is is a promise made by the borrower to repay the debt with interest due at…

Q: A sales representative from South Street Manufacturing (SSM) approached the manager of MD in late…

A: A company's value is determined by adding its book value to the present value of its anticipated…

Q: Differential Analysis for Machine Replacement Ridgeway Digital Components Company assembles circuit…

A: Differential Analysis: Differential analysis is the process of comparing and contrasting the costs…

Q: Profit Planning and Control This case is a manufacturer and could make specialty bikes, ski or…

A: The four financial statements prepared on the basis of these accounting records are Income…

Q: Wildhorse Co. sells a snowboard, WhiteOut, that is popular with snowboard enthusiasts. Presented…

A: Lets understand the basics.Ending inventory and cost of goods sold can be calculated using,(1) FIFO…

Q: Product A B C         Selling price $ 92.00 $ 66.00 $ 82.00 Variable expenses:       Direct…

A: The contribution margin is calculated as the difference between the revenue and variable costs. The…

Q: The following data relate to direct labor costs for August: actual costs for 5,500 hours at $24.00…

A: The direct labor rate variance is a component of the overall labor variance in cost accounting. It…

Q: + 5 5 7 B 8 9 Activity 10 Production Setup 11 Procurement 12 Quality Control 13 Materials Management…

A: Activity-based costing is used to allocate overhead expenses on the basis of activity. Other than…

Q: Lauderdale Corporation is organized in three geographical divisions (regions) with managers…

A: Divisional income is required to evaluate the performance of a divisional manager. The divisional…

Q: he E.N.D. partnership has the following capital balances as of the end of the current year: Pineda…

A: A partnership is a contract between two or more persons to form a business and share profits and…

Q: Blossom Company issues $360,000, 20-year, 10% bonds at 101. Prepare the journal entry to record the…

A: Bonds is a debt market instruments. It is promise to repay the principal along with principal.Issue…

Q: Current Attempt in Progress Kingbird Co. invested $990,000 in Oriole Co. for 25% of its outstanding…

A: The income share increases the investment balance. The dividend share decreases the investment…

Q: Novak Co. sells product P-14 at a price of $48 a unit. The per-unit cost data are direct materials…

A: The Special order should be accepted if Incremental Income is greater than incremental costs.…

Q: Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in…

A: Raw materials are the type of inventory of materials or substances that are used in the production…

Q: Alyeska Services Company, a division of a major oil company provides various services to the…

A: RETURN ON INVESTMENTReturn on investment is one of the profitability ratios which shows how much…

Inventory Valuation

Before discussing the topic inventory valuation let’s discuss the meaning of inventory. In accounting, inventory is also known as stock. Inventory means all the finished goods, materials, merchandise that a business holds for the purpose of selling it in the market with the motive of earning profit.