Based on the following, what is this company's desired BEGINNING inventory for June 1. You must...

Based on the following, what is this company's desired BEGINNING inventory for June 1. You must show work for credit.

Month Budgeted Sales

April $400,000

May $420,000

June $450,000

Cost of Goods Sold as a percentage of current 55%

month's sales

Desired Ending Inventory as a percentage of 15%

NEXT month's Cost of Goods Sold

Solutions

Expert Solution

Solution:

$37,125

Explanation:

closing inventory of may is the beginning inventory of June

May sales = $420,000

May cost of goods sold = 420,000 x 55% = $231,000

June sales = $450,000

June cost of goods sold = $450,000 x 55% = $247,500

Ending inventory of May = 15% of next month cost of goods sold=15% of june cost of goods sold=($247,500) x15%

Ending inventory of may = $37,125 Which is beginning inventory of June

ekkarill92 answered 2 years ago

Next > < Previous

Related Solutions

The following information relates to the inventory of Cameras Ltd during June. June 1 Beginning Inventory...

The following information relates to the inventory of Cameras Ltd during June. June 1 Beginning Inventory 80 units @ $7.00 3 Purchased 90 units @ $8.80 10 Purchased 110 units @ $9.90 12 Sold 90 units 17 Sold 80 units 25 Sold 30 units Cameras Ltd uses a perpetual inventory system, purchases are GST inclusive. Showing calculations, determine the cost of the ending inventory (assuming there have been no stock losses) and the cost of sales, using the following three...

A company's inventory records indicate the following data for the month of April: April 1 Beginning...

A company's inventory records indicate the following data for the month of April: April 1 Beginning 350 units at $18 each April 5 Purchase 290 units at $20 each April 9 Sale 500 units at $55 each April 14 Purchase 250 units at $22 each April 20 Sale 200 units at $55 each April 30 Purchase 240 units at $25 each The company uses the perpetual inventory system What would be the cost of the ending inventory under the following...

At the beginning of June, Circuit Country has a balance in inventory of $2,650. The following...

At the beginning of June, Circuit Country has a balance in inventory of $2,650. The following transactions occur during the month of June. June 2 Purchase radios on account from Radio World for $2,350, terms 2/15, n/45. June 4 Pay cash for freight charges related to the June 2 purchase from Radio World, $330. June 8 Return defective radios to Radio World and receive credit, $300. June 10 Pay Radio World in full. June 11 Sell radios to customers on...

At the beginning of June, Circuit Country has a balance in inventory of $2,900. The following...

At the beginning of June, Circuit Country has a balance in inventory of $2,900. The following transactions occur during the month of June. June 2 Purchase radios on account from Radio World for $2,600, terms 1/15, n/45. June 4 Pay cash for freight charges related to the June 2 purchase from Radio World, $380. June 8 Return defective radios to Radio World and receive credit, $200. June 10 Pay Radio World in full. June 11 Sell radios to customers on...

June production generated the following activity in Axle Chassis Company's Work in Process Inventory account: June...

June production generated the following activity in Axle Chassis Company's Work in Process Inventory account: June 1 balance - $25,000 Direct Materials used - 43,000 Direct labor assigned to jobs - 40,000 Manufacturing overhead allocated to jobs - 16,000 Additionally, Axle has completed Jobs 142 and 143, with total costs of $38,000 and $37,000, respectfully. Requirements: 1) Prepare the journal entry for production completed in June. 2) Open a T-account for Work in Process Inventory. Post the journal entry made...

Park Company's perpetual inventory records indicate the following transactions in the month of June:

Alternative Inventory MethodsPark Company's perpetual inventory records indicate the following transactions in the month of June:UnitsCost/UnitInventory, June 1200$3.20Purchases: June 32003.50 June 172503.60 June 243003.65Sales: June 6300 June 21200 June 27150Required:1.Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: If required, round your answers to the nearest dollar.FIFOCost of Goods Sold$ fill in the blank 1Ending Inventory$ fill in the blank 2LIFO (Round your intermediate calculations and final answers to the nearest cent.)Cost of...

Desired ending inventory is 25% more than beginning inventory. If purchases total $160,000, which of the...

Desired ending inventory is 25% more than beginning inventory. If purchases total $160,000, which of the following statements is true regarding cost of goods sold (COGS)? Explain. A) COGS will exceed cost of goods available for sale. B) COGS will exceed purchases. C) COGS will equal $55,000. D) COGS will be less than purchases.

DATE TRANSACTION # Units Price/Unit June 1 Beginning Inventory 50 $102 June 5 Sale 30 June...

DATE TRANSACTION # Units Price/Unit June 1 Beginning Inventory 50 $102 June 5 Sale 30 June 10 Purchase 100 $110 June 17 Sale 60 June 30 Ending Inventory 60 July 2 Purchase 100 $108 July 8 Sale 110 July 14 Purchase 50 $112 July 18 Sale 40 July 22 Purchase 60 $117 July 26 Sale 50 July 31 Ending Inventory 70 1. Assuming perpetual inventory and LIFO, what is COGS in June? 2. Assuming perpetual inventory and average cost, what...

A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases...

A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases during a month as as follows: Beginning Inventory Jan 1: 16 pairs at $10 ea Purchase Jan 11: 14 pairs @ $12 ea Purchase Jan 20: 23 pairs at $15 ea On Jan 14 the company sold 25 units of shoes. The other 28 units remained in inventory at Jan 31. Question 1: Assuming the company uses the average cost flow assumption what is...

Francis Bellamy Company had the following four inventory purchases in June: Beginning Inventory 150 units $1,500...

Francis Bellamy Company had the following four inventory purchases in June: Beginning Inventory 150 units $1,500 June 10 200 units $2,200 June 15 200 units $2,400 June 28 200 units $2,600 $8,700 A physical count of merchandise inventory on June 30 reveals that there are 80 units on hand. Using FIFO, fill in the adjusting journal entry below using the periodic system for inventory. Enter the answers as whole numbers without a comma or dollar sign. If there is no...

Subjects