Question

Finch Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory...

Finch Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Finch’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $76,000.

Required

  1. Complete the inventory purchases budget by filling in the missing amounts.

  2. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.

  3. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

  • Req A
  • Req B and C

Complete the inventory purchases budget by filling in the missing amounts.

Inventory Purchases Budget
January February March
Budgeted cost of goods sold $52,000 $56,000 $62,000
Plus: Desired ending inventory 8,400
Inventory needed 60,400
Less: Beginning inventory 7,800
Required purchases (on account) $52,600

Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

b. Cost of goods sold
c. Ending inventory

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $69,000 $79,000 $89,000 $95,000 Adams had a beginning inventory balance of $4,500 on April 1 and a beginning balance in accounts payable of $14,300. The company desires to maintain an ending inventory balance equal to 10 percent of the next period’s cost of goods sold. Adams makes all purchases...
Jordan, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Jordan, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $64,000 $74,000 $84,000 $90,000 Jordan had a beginning inventory balance of $2,900 on April 1 and a beginning balance in accounts payable of $14,100. The company desires to maintain an ending inventory balance equal to 20 percent of the next period’s cost of goods sold. Jordan makes all purchases...
Sentra Sporting Company sells tennis rackets and other sporting equipment. The purchasing department manager prepared the...
Sentra Sporting Company sells tennis rackets and other sporting equipment. The purchasing department manager prepared the inventory purchases budget. Sentra's policy is to maintain an ending inventory balance equal to 15% of the following month's cost of goods sold. January's budgeted cost of goods sold is $125,000. October November December Budgeted Cost of Goods Sold 115,000 95,000 105,000 Plus: Desired Ending Inventory 28,000 ? ? Inventory Needed 143,000 ? ? Less: Beginning Inventory 20,000 ? ? Required purchases (on Account)...
Zachary, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Zachary, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $79,000 $89,000 $99,000 $105,000 Zachary had a beginning inventory balance of $4,000 on April 1 and a beginning balance in accounts payable of $15,700. The company desires to maintain an ending inventory balance equal to 15 percent of the next period’s cost of goods sold. Zachary makes all purchases...
Vernon Company, which expects to start operations on January 1, year 2, will sell digital cameras...
Vernon Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Vernon has budgeted sales as indicated in the following table. The company expects a 13 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required Complete the sales budget by filling in the missing amounts. Determine the amount of sales revenue Vernon will report...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget Cash sales $72,000 $68,000 $86,000 Sales on account 86,000 107,000 121,600 Total budgeted sales $158,000 $175,000 $207,600 Schedule of Cash Receipts Current cash...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. 1. July August September Sales Budget Cash sales $67,000 $67,000...
Metro, Inc. sells backpacks. The Company's accountant is preparing the purchases budget for the first quarter...
Metro, Inc. sells backpacks. The Company's accountant is preparing the purchases budget for the first quarter operations. Metro maintains ending inventory at 20% of the following month's expected cost of goods sold. Expected cost of goods sold for April is $82,000. All purchases are made on account with 25% of accounts paid in the month of purchase and the remaining 75% paid in the month following the month of purchase. Sales January February March Budgeted cost of goods sold $...
The budget director for Vernon Cleaning Services prepared the following list of expected selling and administrative...
The budget director for Vernon Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations; accordingly, there are no beginning account balances. Required Complete the schedule of cash payments...
Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is...
Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks: Required October sales are estimated to be $310,000, of which 45 percent will be cash and 55 percent will be credit. The company expects sales to...