nder the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product Ending Inventory Beginning Ending A 500 0.17 0.19 B 50 1.60 1.80 C 100 4.50 4.20 D 40 12.00 13.20 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = What type of weighted aggregate price index must be developed for the LIFO inventory valuation? Laspeyres IndexPaasche index

nder the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product Ending Inventory Beginning Ending A 500 0.17 0.19 B 50 1.60 1.80 C 100 4.50 4.20 D 40 12.00 13.20 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = What type of weighted aggregate price index must be developed for the LIFO inventory valuation? Laspeyres IndexPaasche index

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

	Unit Price ($)
Product	Ending Inventory	Beginning	Ending
A	500	0.17	0.19
B	50	1.60	1.80
C	100	4.50	4.20
D	40	12.00	13.20

Similar questions

In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
Under the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product EndingInventory Beginning Ending A 500 0.15 0.19 B 50 1.40 1.80 C 100 4.50 4.20 D 60 12.00 13.60 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = ?? What type of weighted aggregate price index must be developed for the LIFO inventory valuation? -Paasche index -Laspeyres Index
Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. On the market, Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs $35/L. To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. Assume that…
Omega DB Corp. has a policy of maintaining an inventory of finished goods equal to 40 percent of the next month’s budgeted sales. If Omega DB Corp. plans to produce 6,000 units in June, what are budgeted sales for July in units? Budgeted sales for the first six months of 2019 for Omega DB Corp. are listed below: Units:JANUARY 6,000FEBRUARY 7,000MARCH 8,000APRIL 7,000MAY 5,000JUNE 4,000
Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution please
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…
4) A 12-ounce box of Greenies costs $12.99. A 30-ounce box costs $26.99. (a) What is the cost in dollars per ounce in each box? Which size should you buy? (b) Suppose you have a coupon worth $5 toward the price of any box of Greenies. If you use the coupon, which size should you but? Is it always better to buy the large economy size? (c) Answer the previous question if your coupon gives you a 10% discount rather than $5 off. (d) What's a Greenie? Are these prices reasonable?
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
The Concept of Present Value (PV) and Future Value (FV) involve compounding and discounting. Using Amazon provide real example and discuss how each is used and their importance.
Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?