Prepare schedule to compute the ending inventory

Assignment Help Operation Management
Reference no: EM131377674

Question 1: Martinez Company sells one product. Presented below is information for January for Martinez Company.

Jan. 1

Inventory

107

units at $5 each

4

Sale

84

units at $8 each

11

Purchase

146

units at $6 each

13

Sale

118

units at $9 each

20

Purchase

153

units at $7 each

27

Sale

89

units at $10 each

Martinez uses the FIFO cost flow assumption. All purchases and sales are on account.

Assume Martinez uses a periodic system. Prepare all necessary journal entries, including the end-of-month closing entry to record cost of goods sold. A physical count indicates that the ending inventory for January is 115 units.

Question 2: Pharoah Company was formed on December 1, 2016. The following information is available from Pharoah's inventory records for Product BAP.


Units

Unit Cost

January 1, 2017 (beginning inventory)

726

$ 7.00

Purchases:



   January 5, 2017

1,452

8.00

   January 25, 2017

1,573

9.00

   February 16, 2017

968

10.00

   March 26, 2017

726

11.00

A physical inventory on March 31, 2017, shows 1,936 units on hand.

Prepare schedule to compute the ending inventory at March 31, 2017, under FIFO inventory method.

Question 3: Novak Company uses the LCNRV method, on an individual-item basis, in pricing its inventory items. The inventory at December 31, 2017, consists of products D, E, F, G, H, and I. Relevant per unit data for these products appear below.


Item D

Item E

Item F

Item G

Item H

Item I

Estimated selling price

$149

$136

$118

$112

$136

$112

Cost

93

99

99

99

62

45

Cost to complete

37

37

31

43

37

37

Selling costs

12

22

12

25

12

25

Using the LCNRV rule, determine the proper unit value for balance sheet reporting purposes at December 31, 2017, for each of the inventory items above.

Question 4: Metlock Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis.

Item No.

Quantity

Cost per Unit

Cost to Replace

Estimated Selling Price

Cost of Completion and Disposal

Normal Profit

1320

1,300

$3.23

$3.03

$4.55

$0.35

$1.26

1333

1,000

2.73

2.32

3.54

0.51

0.51

1426

900

4.55

3.74

5.05

0.40

1.01

1437

1,100

3.64

3.13

3.23

0.25

0.91

1510

800

2.27

2.02

3.28

0.81

0.61

1522

600

3.03

2.73

3.84

0.40

0.51

1573

3,100

1.82

1.62

2.53

0.76

0.51

1626

1,100

4.75

5.25

6.06

0.51

1.01

From the information above, determine the amount of Metlock Company inventory.

Question 5: You are called by Tim Duncan of Grouper Co. on July 16 and asked to prepare a claim for insurance as a result of a theft that took place the night before. You suggest that an inventory be taken immediately. The following data are available.

Inventory, July 1

$ 36,600

Purchases-goods placed in stock July 1-15

81,300

Sales revenue-goods delivered to customers (gross)

119,400

Sales returns-goods returned to stock

3,600

Your client reports that the goods on hand on July 16 cost $31,300, but you determine that this figure includes goods of $6,300 received on a consignment basis. Your past records show that sales are made at approximately 30% over cost. Duncan's insurance covers only goods owned.

Compute the claim against the insurance company.

Question 6: ildhorse Lumber Company handles three principal lines of merchandise with these varying rates of gross profit on cost.

Lumber

25%

Millwork

30%

Hardware and fittings

40%

On August 18, a fire destroyed the office, lumber shed, and a considerable portion of the lumber stacked in the yard. To file a report of loss for insurance purposes, the company must know what the inventories were immediately preceding the fire. No detail or perpetual inventory records of any kind were maintained. The only pertinent information you are able to obtain are the following facts from the general ledger, which was kept in a fireproof vault and thus escaped destruction.


Lumber

Millwork

Hardware

Inventory, Jan. 1, 2017

$249,100

$89,700

$44,200

Purchases to Aug. 18, 2017

1,493,800

369,300

158,100

Sales to Aug. 18, 2017

2,085,100

514,800

200,200

Submit your estimate of the inventory amounts immediately preceding the fire.

Question 7: The records of Nash's Boutique report the following data for the month of April.

Sales revenue

$107,900


Purchases (at cost)

$51,200

Sales returns

2,100


Purchases (at sales price)

89,300

Markups

10,900


Purchase returns (at cost)

2,100

Markup cancellations

1,600


Purchase returns (at sales price)

3,200

Markdowns

8,700


Beginning inventory (at cost)

33,024

Markdown cancellations

2,900


Beginning inventory (at sales price)

48,200

Freight on purchases

2,600




Compute the ending inventory by the conventional retail inventory method.

Question 8: Presented below is information related to Indigo Company.


Cost

Retail

Beginning inventory

$ 58,110

$101,500

Purchases (net)

121,450

191,400

Net markups


10,171

Net markdowns


25,358

Sales revenue


192,300

Compute the ending inventory at retail.

Compute a cost-to-retail percentage under the following conditions.

(1) Excluding both markups and markdowns.                       

(2) Excluding markups but including markdowns.                               

(3) Excluding markdowns but including markups.                               

(4) Including both markdowns and markups.                        

Which of the methods in (b) above does the following?

(1) Provides the most conservative estimate of ending inventory.

(2) Provides an approximation of lower-of-cost-or-market.

(3) Is used in the conventional retail method.

Compute ending inventory at lower-of-cost-or-market.

Compute cost of goods sold based on (d).

Compute gross margin based on (d).

Attachment:- Assignment Questions.rar

Reference no: EM131377674

Questions Cloud

What part of texas constitution discusses gubernatorial veto : What part of the Texas Constitution discusses the gubernatorial veto? Indicate for many years this person served as governor. What part of the Texas Constitution (article and section) discusses how the governor is elected?
Discuss the relevant fixed costs : Illustrate a break-even analysis scenario in your industry. Discuss the relevant fixed costs, variable costs, expenses, and revenues. Also discuss a possible break-even point for your scenario
Discuss an exploration of the concept of process evaluation : Process evaluation measures the inputs and outputs of a health program. Using the South University Online Library or the Internet research the concept of process evaluation of a health program. Create a 3- to 4-page Microsoft Word document that i..
How leadership skills of can boost company : How leadership skills of can boost company in comparison to competitors.
Prepare schedule to compute the ending inventory : Pharoah Company was formed on December 1, 2016. The following information is available from Pharoah's inventory records for Product BAP. A physical inventory on March 31, 2017, shows 1,936 units on hand. Prepare schedule to compute the ending inven..
Create a scenario where it would be optimal for a learning : Examine the similarities and differences between learning organizations and learning communities. Create a scenario where it would be optimal for a learning organization and a learning community to collaborate and join forces.
Review both appraisal interview videos : Your two authors provide a number of excellent tips to prepare for and conduct effective performance appraisal interviews. We can better understand both the pitfalls and strengths of actual interviews through observation.Review both appraisal inte..
How the government agencies communicated with each other : Explain how the government agencies (local, state, and federal) communicated with each other and the public? Explain how the wounded were cared for (trauma centers, hospitalizations, search and rescue, etc.)?
Find the number of teeth in each gear : Two gears in a 3:1 ratio gear set and with a diametral pitch of 4 are mounted at a center distance of 6 in. Find the number of teeth in each gear.

Reviews

Write a Review

Operation Management Questions & Answers

  About the organizational culture

Your small company prides itself on providing equal opportunity for all employees, regardless of such factors as age, race, or gender. It has several women and minorities in top positions, and the annual report always features photos that showcase th..

  Federal and provincial government sources

Please search the different support and facilitations, financing sources and incentives available from federal and provincial government sources for entrepreneurs in Canada.

  What is the production quantity that minimizes total cost

The Tableau Co. produces tables. Annual demand for the tables is estimated at 14,000. The assembly department needs the table frames at a rate of 1700 per month. The frame department can produce 2900 frames per month. What is the production quantity ..

  Most effective in the battle of the beers

If you were in charge of marketing for Budweiser or Miller, to what advertising media would you allocate funds in order to be most effective in the "battle of the beers?"

  Calculating the optimal quantity

A large supplier of electronic components has decided to control the inventory of a certain item by a periodic review, order up to R policy. The mean demand rate for this item is 500 units per year.

  Develop a strategy for a new sport product

Develop a strategy for a new sport product. In your answer describe the sport product and include, and thoroughly explain, all pertinent steps in developing the strategy.

  When conducting its market assessment

When conducting its market assessment, what economic factors should Moots consider to make its decision? Which market do you expect will be more lucrative for Moots? Why?

  The role of public relations in the media and to the public

Give an example of professional experience, Discuss the term "spin” as it relates to the role of public relations in the media and to the public. Include consideration of Meerman Scott's (2013) new rules of marketing and PR points:

  What allows him entrance into heaven

Discuss the concept of atonement in Islam versus Christian Theism.  How does man find forgiveness, and what allows him entrance into heaven?

  Opportunities might this company have for global expansion

Kohl’s Corporation is a very large and successful US retailer. It has no physical or Internet retail outlets outside the United States. What opportunities might this company have for global expansion? What modes should it explore? Should Kohl’s stay ..

  Why is the business location important

Why is the business location important? Explain why Forecasting and Capacity Planning are essential in all businesses.

  Determining the effectiveness of scheduling decision

Selecting the correct scheduling technique depends on the volume of orders, the nature of operations, and the complexity of the jobs. There are four criteria that are used in operations to evaluate scheduling performance. List and explain the four cr..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd