Problem Set 2 Inventory Value (10 pts) The following inventory records for the Tacky Tea Shoppe...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem Set 2 Inventory Value (10 pts) The following inventory records for the Tacky Tea Shoppe reveal the following information about one item in inventory during the month of January. This data will be used for this problem set. 1/1 Opening Inventory 12 units valued at $1.05 per unit (unit = pkg of tea) 1/5 Purchased 18 units@ $1. 15/unit 18 units @ $1.20/unit 1/12 Purchased 1/19 Purchased 1/26 Purchased 12 units@ $1.30/unit 6 units @ $1.40/unit On January 31, the physical inventory shows nine units of tea left in stock. Determine the value of the closing inventory for the items using actual, LIFO, FIFO, and weighted average inventory valuation methods. (For actual purchase: assignment is done for you; assume 3 of the 9 units come from each of the last 3 deliveries). Complete the following table to show the values for each cell. The Actual Cost column is done as an example; complete the Ending Inventory and COGS for the other two (make sure to complete them as they are done for Actual Cost column) COGS Formula | Actual Cost Beg Inv. + Purchases = Total - Ending Inv. = COGS LIFO (this column is done for (these three you) 12 units @ 1.05 = $12.60 18 units @ 1.15 $20.70 18 units @ 1.20 $21.60 12 units @ 1.30 = $15.60 6 units @ 1.40= $8.40 Total = $66.30 $78.90 Actual Cost End Inv Value = 3 units @ 1.40 = 4.20 3units @ 1.30 3.90 3 units @1.20 3.60 $11.70 End Inv. value for remaining 9. $78.90-$11.70= $67.20 columns and the open cells below are to be calculated) 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 LIFO End Inventory Value = FIFO 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 FIFO End Inventory Value = Weighted Average 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 Wt Average End Inventory Value = Projecting menu purchase quantities The menu also influences how product is purchased. In an operation with a menu cycle and a fixed audience or clientele, purchase quantities are based on recipes, portion sizes and quantities specified in the recipes. That is because most people have only one choice. Other operations that serve a fairly static menu with several choices of item, there needs to be a way to forecast and project menu item need order to purchase adequate amounts of food. One such method is called the usage ratio. A usage ratio is based on previous history. Production records or Point of Sales (POS) systems with retail cash sales record the quantities of food served based on customer count. The following is an example of using a production record: Sunday Filet Chimichanga Yakisoba Usage Ratio: 107 lb 435 customers Actual customer count 435 435 435 ¾ case 435 customers 515 people Purchase need: 78 servings 0.179 servings/customer for yakisoba 435 customers The usage factor can then be applied at later dates when customer counts are projected to differ. The customer count in a hospital or school may vary with census or enrollments. Likewise, if the cycle is repeated, approximations of the total number expected to be served can be forecast. X Customer count by portion size In buffets or catering, the determination of quantity to purchase may include the use of calculating portions needed times the portion size. This is the easiest method to determine portion quantity. Consider this example, assume that the product has no weight loss in preparation: Customer count Portion size = Customer count Portion size 275 people X 3oz. Serving 0.246 lb/customer for filet 1545 oz. EP Actual usage 107 lb ¾ case 78 servings 0.002 case/customer for chimichanga 1 lb. 16 oz Another method for calculating purchases by portion size when you are projecting units or purchasing on the basis of count when you are not buying a bulk quantity of food, but a portioned amount. That is actually simple as all you need to do is know the portions per serving and the total portions: X 2 butter patties x Person 0.35 oz serving Purchase Need = 1545 oz. EP or AS (as served) 96.56 or 96 lbs. Purchase Need = 192.5 oz butter pats or 550 butter pats 17 lb case butter patties contains 4 sleeves of 4.25 lb portion butter round tubs or 799 foil wrapped portions. How many cases do you need? Problem Set 2 Inventory Value (10 pts) The following inventory records for the Tacky Tea Shoppe reveal the following information about one item in inventory during the month of January. This data will be used for this problem set. 1/1 Opening Inventory 12 units valued at $1.05 per unit (unit = pkg of tea) 1/5 Purchased 18 units@ $1. 15/unit 18 units @ $1.20/unit 1/12 Purchased 1/19 Purchased 1/26 Purchased 12 units@ $1.30/unit 6 units @ $1.40/unit On January 31, the physical inventory shows nine units of tea left in stock. Determine the value of the closing inventory for the items using actual, LIFO, FIFO, and weighted average inventory valuation methods. (For actual purchase: assignment is done for you; assume 3 of the 9 units come from each of the last 3 deliveries). Complete the following table to show the values for each cell. The Actual Cost column is done as an example; complete the Ending Inventory and COGS for the other two (make sure to complete them as they are done for Actual Cost column) COGS Formula | Actual Cost Beg Inv. + Purchases = Total - Ending Inv. = COGS LIFO (this column is done for (these three you) 12 units @ 1.05 = $12.60 18 units @ 1.15 $20.70 18 units @ 1.20 $21.60 12 units @ 1.30 = $15.60 6 units @ 1.40= $8.40 Total = $66.30 $78.90 Actual Cost End Inv Value = 3 units @ 1.40 = 4.20 3units @ 1.30 3.90 3 units @1.20 3.60 $11.70 End Inv. value for remaining 9. $78.90-$11.70= $67.20 columns and the open cells below are to be calculated) 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 LIFO End Inventory Value = FIFO 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 FIFO End Inventory Value = Weighted Average 12 units @ 1.05 = $12.60 18 units @ 1.15 = 20.70 18 units @ 1.20 = 21.60 12 units @ 1.30 = 15.60 6 units @ 1.40 = 8.40 Total = 66.30 78.90 Wt Average End Inventory Value = Projecting menu purchase quantities The menu also influences how product is purchased. In an operation with a menu cycle and a fixed audience or clientele, purchase quantities are based on recipes, portion sizes and quantities specified in the recipes. That is because most people have only one choice. Other operations that serve a fairly static menu with several choices of item, there needs to be a way to forecast and project menu item need order to purchase adequate amounts of food. One such method is called the usage ratio. A usage ratio is based on previous history. Production records or Point of Sales (POS) systems with retail cash sales record the quantities of food served based on customer count. The following is an example of using a production record: Sunday Filet Chimichanga Yakisoba Usage Ratio: 107 lb 435 customers Actual customer count 435 435 435 ¾ case 435 customers 515 people Purchase need: 78 servings 0.179 servings/customer for yakisoba 435 customers The usage factor can then be applied at later dates when customer counts are projected to differ. The customer count in a hospital or school may vary with census or enrollments. Likewise, if the cycle is repeated, approximations of the total number expected to be served can be forecast. X Customer count by portion size In buffets or catering, the determination of quantity to purchase may include the use of calculating portions needed times the portion size. This is the easiest method to determine portion quantity. Consider this example, assume that the product has no weight loss in preparation: Customer count Portion size = Customer count Portion size 275 people X 3oz. Serving 0.246 lb/customer for filet 1545 oz. EP Actual usage 107 lb ¾ case 78 servings 0.002 case/customer for chimichanga 1 lb. 16 oz Another method for calculating purchases by portion size when you are projecting units or purchasing on the basis of count when you are not buying a bulk quantity of food, but a portioned amount. That is actually simple as all you need to do is know the portions per serving and the total portions: X 2 butter patties x Person 0.35 oz serving Purchase Need = 1545 oz. EP or AS (as served) 96.56 or 96 lbs. Purchase Need = 192.5 oz butter pats or 550 butter pats 17 lb case butter patties contains 4 sleeves of 4.25 lb portion butter round tubs or 799 foil wrapped portions. How many cases do you need?
Expert Answer:
Answer rating: 100% (QA)
Answers 1 2 3 4 COGS Formula 1 Beginnning Inventory Add Purchases Total Less Ending I... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these general management questions
-
During the month of January 20-2, TJs Specialty Shop engaged in the following transactions: Jan. 1 Sold merchandise on account to Anne Clark, $3,000, plus tax of $150. Sale No. 643. 2 Issued Check...
-
Aikman Corporation has the following cost records for June 2010. Instructions(a) Prepare a cost of goods manufactured schedule for June 2010.(b) Prepare an income statement through gross profit for...
-
Troy Corporation has the following cost records for June 2012. Instructions(a) Prepare a cost of goods manufactured schedule for June 2012.(b) Prepare an income statement through gross profit for...
-
How do standard costs illustrate the trade-off between decision making and control?
-
What are the advantages and disadvantages of prototyping?
-
A solid steel shaft is required to transmit \(45 \mathrm{~kW}\) at \(150 \mathrm{rpm}\). If the permissible shear stress is \(75 \mathrm{MPa}\), find the diameter of the shaft.
-
The rod has a circular cross section with a polar moment of inertia \(J\) and moment of inertia \(I\). If a vertical force \(\mathbf{P}\) is applied at \(A\), determine the vertical displcement at...
-
Lloyd Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price ................ $45.00...
-
Tariffs, import quotas, and export subsidies are the three sets of tools that governments commonly use to restrict international trade to protect domestic producers from foreign competition. (3.a)...
-
1) Use the base case assumptions as well as the information presented in the case to build a four-year discounted cash flow model for Advanced Seal given a 50% cannibalization rate for the Premium...
-
Discuss one of the bankrupt companies that occurred in the world economy including the following: The main causes of bankruptcy The important lessons from the bankrupt company The impact of the...
-
Explain how Balogun and Hailey's Change Model might be used during an organizational change.?
-
Two identical steel balls are released from rest from the same height and travel along track. Assume that balls roll without slipping during the entire motion, and they never lose contact with the...
-
A tennis ball is hit with a tennis racket and the change in the momentum of the ball is 4.0 kg.m/s. If the collision time of the ball and racket is 0.01 s, what is the magnitude of the force exerted...
-
You are asked to write a program for a bookstore that will be launching soon. The bookstore has three types of items: textbooks, apparels, and gift items. Each item has an item name and sales price....
-
Harvard University student Mark Zuckerberg created a website that eventually turned into Facebook. In the beginning phases, he approached his friend, Eduardo, his vision for the website as an online...
-
Describe and discuss Intrinsic Motivation and Intrinsic Motivators as they relate to employee retention. Provide examples of any Intrinsic Motivators at your workplace and how they can help with...
-
Uniform electric field in Figure a uniform electric field is directed out of the page within a circular region of radius R = 3.00 cm. The magnitude of the electric field is given by E = (4.50 x 10-3...
-
On December 31, a company makes a $ 9,000 payment for renting a warehouse in January, February, and March of the following year. Show the accounting equation effects of the transaction on December...
-
Access the Wiki Art Gallery (WAG) instructional case in Connect and read the case in sufficient depth to answer the following questions. 1. What method for depreciation does WAG use and is this...
-
The average price of a gallon of gas in 2013 dropped $ 0.12 (3 percent) from $ 3.61 in 2012 (to $ 3.49 in 2013). Lets see whether these changes are reflected in the income statement of Chevron...
-
For the conditions of Sample Problem 5/17, determine the angular acceleration of \(A C\) and the acceleration of \(A\) relative to the rotating slot in \(\operatorname{arm} O D\). Problem 5/17, The...
-
Aircraft \(B\) has a constant speed of \(150 \mathrm{~m} / \mathrm{s}\) as it passes the bottom of a circular loop of 400-m radius. Aircraft \(A\) flying horizontally in the plane of the loop passes...
-
Examples of random variables used in this chapter included (a) the sex of the next person you meet, (b) the number of times a wireless network fails, (c) the time it takes to commute to school, (d)...
Study smarter with the SolutionInn App