Question

In: Accounting

The firm's inventory policy is to have ending inventory equal to 10% of next month's sales.

The firm's inventory policy is to have ending inventory equal to 10% of next month's sales.
Fill in the missing numbers.


FebruaryMarchApril
Ending inventory

5,000
Beginning inventory


Budgeted sales12,00013,00019,000
Budgeted production


(If you get stuck on the beginning inventory for February: it is equal to the ending inventory for January, which you can compute with the available data on February sales)

Solutions

Expert Solution

Beginning inventory+Budgeted production-Ending inventory=Budgeted sales

February March April
Ending inventory (10%*13000)=1300 (10%*19000)=1900 5000
Beginning inventory (10%*12000)=1200 1300 1900
Budgeted sales 12000 13000 19000
Budgeted production (12000+1300-1200)=12100 (13000+1900-1300)=13600 (19000+5000-1900)=22100

Related Solutions

The ending finished goods inventory should equal 30% of the following month's sales. The budgeted required production for February is closest to:
Cardel Corporation makes one product. Budgeted unit sales are shown below:Budgeted unit sales January 7,300 February 8,600 March 10,100 April 13,600  The ending finished goods inventory should equal 30% of the following month's sales. The budgeted required production for February is closest to:A. 11,630 unitsB. 14,210 unitsC. 9,050 unitsD. 8,600 units
The Cookie Shop's purchases are equal to 63 percent of the following month's sales. The accounts...
The Cookie Shop's purchases are equal to 63 percent of the following month's sales. The accounts payable period for purchases is 30 days while all other expenditures are paid in the month they are incurred. Assume each month has 30 days. The company has compiled the following information. April May June Sales $ 7,100 $ 7,400 $ 7,800 Other expenses 1,625 1,675 1,925 Interest and taxes 380 390 410 What are the company's total cash disbursements for May?
There are 10 units in ending inventory compute the value of the ending inventory using the...
There are 10 units in ending inventory compute the value of the ending inventory using the periodic inventory method. Compute the answer using FIFO, LIFO and the average cost methods. (round your answer to the nearest whole number) Price Cost Number Per Per Date Transaction of units unit Purchase Apr. 3 Inventory 2 10 20 8 Purchase 2 15 30 11 Purchase 3 20 60 30 Purchase 2 25 50 May 8 Purchase 3 25 75 10 Purchase 3 30...
CCC currently has sales of $24,000,000 and projects sales of $30,000,000 for next year. The firm's...
CCC currently has sales of $24,000,000 and projects sales of $30,000,000 for next year. The firm's current assets equal $6,000,000 while its fixed assets are $7,000,000. The best estimate is that current assets will rise directly with sales while fixed assets will rise by $400,000. The firm presently has $2,400,000 in accounts payable, $1,400,000 in long-term debt, and $9,200,000 in common equity. All current liabilities are expected to change directly with sales. CCC plans to pay $800,000 in dividends next...
CCC currently has sales of $24,000,000 and projects sales of $30,000,000 for next year. The firm's...
CCC currently has sales of $24,000,000 and projects sales of $30,000,000 for next year. The firm's current assets equal $6,000,000 while its fixed assets are $7,000,000. The best estimate is that current assets will rise directly with sales while fixed assets will rise by $400,000. The firm presently has $2,400,000 in accounts payable, $1,400,000 in long-term debt, and $9,200,000 in common equity. All current liabilities are expected to change directly with sales. CCC plans to pay $800,000 in dividends next...
CCC currently has sales of $27,000,000 and projects sales of $36,450,000 for next year. The firm's...
CCC currently has sales of $27,000,000 and projects sales of $36,450,000 for next year. The firm's current assets equal $7,000,000 while its fixed assets are $8,000,000. The best estimate is that current assets will rise directly with sales while fixed assets will rise by $200,000. The firm presently has $3,500,000 in accounts payable, $1,400,000 in long-term debt, and $10,100,000 in common equity. All current liabilities are expected to change directly with sales. CCC plans to pay $900,000 in dividends next...
Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales...
Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales Returns and Allowances 3,600 Purchase Discounts 2,400 Transportation-In 4,400 Purchase Returns and Allowances 3,600 Sales Discounts 1,920 Required: a.     Determine net sales b.     Determine net cost of purchases c.     Determine gross margin d.     Determine cost of goods available for sale e.     Determine cost of goods sold (Show your work for each calculation labeling each amount included.)
1) Calculate the missing amounts for each company. Sales Revenue Beginning Inventory Inventory Purchases Ending Inventory...
1) Calculate the missing amounts for each company. Sales Revenue Beginning Inventory Inventory Purchases Ending Inventory COGS Gross Profit Company 1 $100,000 $20,000 $65,000 $22,000 A B Company 2 $140,000 $25,000 C $30,000 D $45,000 Company 3 E F $45,000 $20,000 $50,000 $35,000 Company 4 $85,000 $10,000 $30,000 G $35,000 H
Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December...
Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December 31 for Holland Company are shown below. 20Y4 20Y3 Cost of merchandise sold $1,778,280 $1,093,905 Inventories:   Beginning of year 347,480 243,820   End of year 499,320 347,480 a. Determine the inventory turnover for 20Y4 and 20Y3. Round to one decimal place. Inventory Turnover 20Y4 20Y3 b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and...
Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December...
Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Y7 20Y6 Cost of goods sold $3,791,255 $4,040,550 Inventories: Beginning of year 766,500 730,000 End of year 846,800 766,500 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Y7 20Y6 Inventory turnover b. Determine the number of days’ sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT