Question

The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January 1st. ItASSETS AS OF DECEMBER 31, Cash Accounts receivable Inventory Prepaid insurance Fixed assets, net $4,000 16,000 31,250 1,200 1February March 1 Cash Collections Schedule 2 Collections for the month of: 3 November 4 December 5 January 6 February 7 March

Problem: Complete the Purchase Budget (below) using Excel: Provide the formula cell view rather than the numerical answer.

Purchase Budget

December

January

February

March

Desired Ending Inventory

Cost of Goods Sold

Total Needed

Beginning Inventory

Purchases

0 0
Add a comment Improve this question Transcribed image text
Answer #1

fox X 123 Oil and Gas Company- Purchase Budget A1 A В с D E F G Н K 123 Oil and Gas Company- Purchase Budget 1 Particulars De

Add a comment
Know the answer?
Add Answer to:
Problem: Complete the Purchase Budget (below) using Excel: Provide the formula cell view rather than the numerical answ...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Complete the Cash Collections Schedule: Provide the formula cell view rather than the numerical answer. Cash...

    Complete the Cash Collections Schedule: Provide the formula cell view rather than the numerical answer. Cash Collections Schedule January February March 60% of current months sale                 30% of previous months sale 10% of second previous months sale Total collections The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January 1st. It desires an ending minimum cash balance of $4,000 each month. Sales are forecasted at an average selling price/transfer...

  • Requirement: Complete the various budget schedules using Excel. Submit one hard copy per group and email me your Excel s...

    Requirement: Complete the various budget schedules using Excel. Submit one hard copy per group and email me your Excel spreadsheet. In Excel use formulas wherever possible. Avoid “hard coding” because I will test the flexibility of your spread sheet by changing certain cells such as sales. To be discussed further in class as well. The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January 1st. It desires an ending minimum...

  • Problem Solving Completing a Master Budget: The following data relate to the operations of Rebel Corporation,...

    Problem Solving Completing a Master Budget: The following data relate to the operations of Rebel Corporation, a wholesale distributor of consumer goods. Current assets as of December 31: Cash Accounts receivable Inventory Buildings and equipment Accounts payable Capital Stock Retained earnings 15,000 25,000 18,500 110.000 35.000 100,000 23,500 a. The gross margin is 40% of sales (so cost of goods sold is 60% of sales) b. Actual and budgeted sales data are as follows: Below table indicates sales for December...

  • INSTRUCTIONS: Based on the information available below, complete the Cash Budget, Income Statement, and Budgeted Balance...

    INSTRUCTIONS: Based on the information available below, complete the Cash Budget, Income Statement, and Budgeted Balance Sheet worksheet 4 A relatively new company, Get Laughy Taffy, Inc., has determined they need to engage in a budgeting 5 process as part of their new strategic plan. The Company has asked you to provide the following items 6 for the months of January, February, and March of 2020: A) a Purchases Budget; B) a Cash Budget; C) a 7 Budgeted Income Statement;...

  • Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six...

    Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six months of 2017 are as follows: Month Unit Sales Month Unit Sales January 155,000 April 240,000 February 185,000 May 205,000 March 225,000 June 265,000 Beginning inventory for 2017 is 35,000 units. The budgeted inventory at the end of a month is 40 percent of units to be sold the following month. Purchase price per unit is $5. Prepare a purchases budget in units and...

  • (Cash budget​) The Sharpe​ Corporation's projected sales for the first 8 months of 2016 are shown...

    (Cash budget​) The Sharpe​ Corporation's projected sales for the first 8 months of 2016 are shown in the following​ table: January ​$170,000 May ​ $280,000    February $100,000 June $250,000 March $115,000 July  $205,000 April $220,000 August  $130,000 Of​ Sharpe's sales, 30 percent is for​ cash, another 40 percent is collected in the month following the​ sales, and 30 percent is collected in the second month following sales. November and December sales for 2015 were $200,000 and $155,000​, respectively. Sharpe...

  • Excel Assignment John L Leal Company, an office supplies specialty store, prepares its master budget on...

    Excel Assignment John L Leal Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Cash $ 48,000 Accounts receivable 224,000 Inventory 60,000 Buildings and equipment (net) 370,000 Accounts payable Common stock Retained earnings $ 702,000 $ 93,000 500,000...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017 Dils Brother Department Store Balance Sheet March 31, 2017 Liabilities and Stockholders' Equity Assets Cash $4,000 Accounts payable $31,000 Dividends payable 15,000 Accounts recelvable 31,000 Rent payable Inventory 36,000 3,000 Prepaid Insurance Stockholders' equity 3,000 50,000 Fixtures 25,000 Total liabilities and equity $99,000 Total assets $99,000 Actual and forecasted sales...

  • Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following...

    Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $4,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 3,000 Prepaid Insurance 2,000 Stockholders' equity 40,000 Fixtures 25,000 Total assets $86,000 Total liabilities and equity $86,000 Actual and forecasted sales for selected...

  • Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures:...

    Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000 $220,000 $280,000 $320,000 $340,000 $330,000 Thirty percent of each month's sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT