Sim-Jo-La Electronics sells a variety of electronic devices including a variety of WIFI SMART camera bulbs. The business began the second quarter (April to June) of 2020 with 15 (V380PRO) camera bulbs at a total cost of $108,750. The following transactions relating to the "V380PRO" camera bulbs were completed during the quarter. 90 bulbs were purchased at a cost of $6,850 each. In addition, the business paid freight charges of $800 cash on each bulb to have the inventory shipped from the point of purchase to their warehouse. April 7 April 30 The sales for April were 75 bulbs which yielded total sales revenue of $803,250. (15 of these bulbs were sold on account to longstanding customers of the business) May 6 A new batch of 80 bulbs was purchased at a total cost of $654,800 Мay 9 Upon inspection of the bulbs purchased on May 6, five (5) of the units were found to be defective and were returned to the supplier. May 31 During the month 62 of the camera bulbs were sold at a price of $11,450 each. A customer, to whom 7 of the bulbs were sold during the first business day of May, returned 3 units of the merchandise, as they were of another make & model. June 5 June 14 Owing to an increased demand, a further 110 bulbs were purchased at a cost of $9,000 each; the supplier gave a 3% quantity discount on the purchase. June 30 116 bulbs were sold during June at a unit selling price of $12,250. June 30 An actual count of inventory was carried out at the close of business which revealed that there were 36 units of the V380PRO brand of merchandise in the store room. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: Prepare a perpetual inventory record for this merchandise, using the first in, first out (FIFO) method of inventory valuation to determine the company's cost of goods sold for the quarter and the value of ending. (A) Given that selling, distribution and administrative costs associated with the V380PRO brand of WIFI SMART camera bulbs for the quarter were $27,255, $42,400 and $145,600 respectively, prepare an income statement for Sim-Jo-La (V380PRO) for the quarter ended June 30, 2020. (B) (C) Journalize the transactions for the month of April, assuming the company uses a: Periodic inventory system Perpetual inventory syst One of the managers of the business has indicated that his main objective is to cut back on his tax liability as much as possible and is of the view that the FIFO method would be best. Do you agree with him? Explain your answer clearly, with reference to the most popular methods of inventory valuation. (D) Universal Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. (E) i) What is the total stock administrative cost of Universal's current inventory policya ii) Is this the entity's cost minimizing solution for this product each year? Explain.

Sim-Jo-La Electronics sells a variety of electronic devices including a variety of WIFI SMART camera bulbs. The business began the second quarter (April to June) of 2020 with 15 (V380PRO) camera bulbs at a total cost of $108,750. The following transactions relating to the "V380PRO" camera bulbs were completed during the quarter. 90 bulbs were purchased at a cost of $6,850 each. In addition, the business paid freight charges of $800 cash on each bulb to have the inventory shipped from the point of purchase to their warehouse. April 7 April 30 The sales for April were 75 bulbs which yielded total sales revenue of $803,250. (15 of these bulbs were sold on account to longstanding customers of the business) May 6 A new batch of 80 bulbs was purchased at a total cost of $654,800 Мay 9 Upon inspection of the bulbs purchased on May 6, five (5) of the units were found to be defective and were returned to the supplier. May 31 During the month 62 of the camera bulbs were sold at a price of $11,450 each. A customer, to whom 7 of the bulbs were sold during the first business day of May, returned 3 units of the merchandise, as they were of another make & model. June 5 June 14 Owing to an increased demand, a further 110 bulbs were purchased at a cost of $9,000 each; the supplier gave a 3% quantity discount on the purchase. June 30 116 bulbs were sold during June at a unit selling price of $12,250. June 30 An actual count of inventory was carried out at the close of business which revealed that there were 36 units of the V380PRO brand of merchandise in the store room. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: Prepare a perpetual inventory record for this merchandise, using the first in, first out (FIFO) method of inventory valuation to determine the company's cost of goods sold for the quarter and the value of ending. (A) Given that selling, distribution and administrative costs associated with the V380PRO brand of WIFI SMART camera bulbs for the quarter were $27,255, $42,400 and $145,600 respectively, prepare an income statement for Sim-Jo-La (V380PRO) for the quarter ended June 30, 2020. (B) (C) Journalize the transactions for the month of April, assuming the company uses a: Periodic inventory system Perpetual inventory syst One of the managers of the business has indicated that his main objective is to cut back on his tax liability as much as possible and is of the view that the FIFO method would be best. Do you agree with him? Explain your answer clearly, with reference to the most popular methods of inventory valuation. (D) Universal Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. (E) i) What is the total stock administrative cost of Universal's current inventory policya ii) Is this the entity's cost minimizing solution for this product each year? Explain.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Related questions

Question

What's the correct answer for D and e

Transcribed Image Text:Sim-Jo-La Electronics sells a variety of electronic devices including a variety of WIFI SMART camera bulbs. The business began the second quarter (April to June) of 2020 with 15 (V380PRO) camera bulbs at a total cost of $108,750. The following transactions relating to the "V380PRO" camera bulbs were completed during the quarter. April 7 90 bulbs were purchased at a cost of $6,850 each. In addition, the business paid freight charges of $800 cash on each bulb to have the inventory shipped from the point of purchase to their warehouse. April 30 The sales for April were 75 bulbs which yielded total sales revenue of $803,250. (15 of these bulbs were sold on account to longstanding customers of the business) Мaу 6 A new batch of 80 bulbs was purchased at a total cost of $654,800 Мay 9 Upon inspection of the bulbs purchased on May 6, five (5) of the units were found to be defective and were returned to the supplier. May 31 During the month 62 of the camera bulbs were sold at a price of $11,450 each. A customer, to whom 7 of the bulbs were sold during the first business day of May, returned 3 units of the merchandise, as they were of another make & model. June 5 Owing to an increased demand, a further 110 bulbs were purchased at a cost of $9,000 each; the supplier gave a 3% quantity discount on the purchase. June 14 June 30 116 bulbs were sold during June at a unit selling price of $12,250. June 30 An actual count of inventory was carried out at the close of business which revealed that there were 36 units of the V380PRO brand of merchandise in the store room. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: Prepare a perpetual inventory record for this merchandise, using the first in, first out (FIFO) (A) method of inventory valuation to determine the company's cost of goods sold for the quarter and the value of ending. Given that selling, distribution and administrative costs associated with the V380PRO brand of WIFI SMART camera bulbs for the quarter were $27,255, $42,400 and $145,600 respectively, prepare an income statement for Sim-Jo-La (V380PRO) for the quarter ended June 30, 2020. (B) (C) Journalize the transactions for the month of April, assuming the company uses a: Periodic inventory system Perpetual inventory system One of the managers of the business has indicated that his main objective is to cut back on his tax liability as much as possible and is of the view that the FIF0 method would be best. Do you agree with him? Explain your answer clearly, with reference to the most popular methods of inventory valuation. (D) (E) Universal Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. i) What is the total stock administrative cost of Universal's current inventory policy ii) Is this the entity's cost minimizing solution for this product each year? Explain.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here