Question

In: Accounting

Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...

Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 4 percent for peaches and 9 percent for oranges. The current year’s sales revenue data follow:

First Quarter Second Quarter Third Quarter Fourth Quarter Total
Peaches $ 237,000 $ 257,000 $ 317,000 $ 257,000 $ 1,068,000
Oranges 406,000 456,000 576,000 386,000 1,824,000
Total $ 643,000 $ 713,000 $ 893,000 $ 643,000 $ 2,892,000

Based on the company’s past experience, cost of goods sold is usually 60 percent of sales revenue. Company policy is to keep 15 percent of the next period’s estimated cost of goods sold as the current period’s ending inventory. (Hint: Use the cost of goods sold for the first quarter to determine the beginning inventory for the first quarter.)

Required

  1. Prepare the company’s sales budget for the next year for each quarter by individual product.

  2. If the selling and administrative expenses are estimated to be $670,000, prepare the company’s budgeted annual income statement.

  3. Ms.Jasper estimates next year’s ending inventory will be $34,700 for peaches and $57,300 for oranges. Prepare the company’s inventory purchases budgets for the next year, showing quarterly figures by product.

Prepare the company’s sales budget for the next year for each quarter by individual product.

First Quarter Second Quarter Third Quarter Fourth Quarter Total
Peaches
Oranges
Total

If the selling and administrative expenses are estimated to be $670,000, prepare the company’s budgeted annual income statement.

JASPER FRUITS CORPORATION
Budgeted Annual Income Statement

Ms. Jasper estimates next year’s ending inventory will be $34,700 for peaches. Prepare the company’s inventory purchases budgets for the next year, showing quarterly figures by product. (Round your final answers to nearest whole dollar.)

First Quarter Second Quarter Third Quarter Fourth Quarter
Inventory needed
Required purchases

\

Ms. Jasper estimates next year’s ending inventory will be $57,300 for oranges. Prepare the company’s inventory purchases budgets for the next year, showing quarterly figures by product. (Round your final answers to nearest whole dollar.)

First Quarter Second Quarter Third Quarter Fourth Quarter
Inventory needed
Required purchases

Solutions

Expert Solution

Sales and Purchase Budget for Jasper Fruits Corporation:

Please give a thumbs up if you find this answer useful!

a. Sales Budget for Next Year:

b. Budgeted Annual Income Statement:



c.  Inventory Purchases Budgets for The Next Year:


Related Solutions

Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 6 percent for peaches and 11 percent for oranges. The current year’s sales revenue data follow. First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 237,000 $ 257,000 $ 317,000 $ 257,000 $ 1,068,000 Oranges 414,000 464,000 584,000 394,000 1,856,000 Total $ 651,000 $ 721,000 $ 901,000 $ 651,000 $ 2,924,000...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 6 percent for peaches and 11 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 229,000 $ 249,000 $ 309,000 $ 249,000 $ 1,036,000 Oranges 405,000 455,000 575,000 385,000 1,820,000 Total $ 634,000 $ 704,000 $ 884,000 $ 634,000 $ 2,856,000...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 6 percent for peaches and 11 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 238,000 $ 258,000 $ 318,000 $ 258,000 $ 1,072,000 Oranges 419,000 469,000 589,000 399,000 1,876,000 Total $ 657,000 $ 727,000 $ 907,000 $ 657,000 $ 2,948,000...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 3 percent for peaches and 8 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 237,000 $ 257,000 $ 317,000 $ 257,000 $ 1,068,000 Oranges 400,000 450,000 570,000 380,000 1,800,000 Total $ 637,000 $ 707,000 $ 887,000 $ 637,000 $ 2,868,000...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 3 percent for peaches and 8 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 229,000 $ 249,000 $ 309,000 $ 249,000 $ 1,036,000 Oranges 410,000 460,000 580,000 390,000 1,840,000 Total $ 639,000 $ 709,000 $ 889,000 $ 639,000 $ 2,876,000...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to...
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 7 percent for peaches and 12 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 228,000 $ 248,000 $ 308,000 $ 248,000 $ 1,032,000 Oranges 412,000 462,000 582,000 392,000 1,848,000 Total $ 640,000 $ 710,000 $ 890,000 $ 640,000 $ 2,880,000...
Corporation wholesales peaches and oranges. Ms. Jasper is working with the company’s accountant to prepare next...
Corporation wholesales peaches and oranges. Ms. Jasper is working with the company’s accountant to prepare next year’s budget. Ms. Jasper estimates that sales will increase 6 percent for peaches and 11 percent for oranges. The current year’s sales revenue data follow: First Quarter Second Quarter Third Quarter Fourth Quarter Total Peaches $ 232,000 $ 252,000 $ 312,000 $ 252,000 $ 1,048,000 Oranges 411,000 461,000 581,000 391,000 1,844,000 Total $ 643,000 $ 713,000 $ 893,000 $ 643,000 $ 2,892,000 Based on...
You are working as a cost accountant of Proctor and Gamble company’s detergents manufacturing division. Currently...
You are working as a cost accountant of Proctor and Gamble company’s detergents manufacturing division. Currently the demand of Ariel is 550 units a month. The company is selling one Ariel package at a price of 100. The variable cost of ne unit is 62 and fixed cost is 15000. The company is planning to design a new sales promotional campaign that will cost the company 7000 extra. The company is forecasting that by starting new sales promotional campaign company’s...
You are an accountant at Evil Corporation. Your company is working to expand operations to another...
You are an accountant at Evil Corporation. Your company is working to expand operations to another state. The company asked you to prepare financial statements to present to the bank to obtain financing. The income statement you prepared shows a loss of $2,000 for the current fiscal period. When you presented the figures to your immediate supervisor, Mr. Lucifer Strong, he informs you that these figures will not fly. He tells you to go back to the income statement and...
The accountant for Taryn Corporation prepared the following list of account balances from the Company’s records...
The accountant for Taryn Corporation prepared the following list of account balances from the Company’s records for the year ended December 31, 2014: Sales revenue                                           $165,000                           Cash                                    $ 30,000 Accounts receivable                                   14,000                           Selling expenses                   44,000 Equipment                                                    42,000                           Common stock                      41,000 Accounts payable                                        12,000                         Interest income                        3,000 Salaries and wages expense                     40,000                            Cost of sales                           51,000 Inventories                                                   22,000                         Prepaid expenses                      2,000 Income taxes payable                                  5,000                           Income taxes expense           18,000 Notes payable                                             20,000                          Retained earnings                          ? Required: Answer the following questions for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT