Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarters activity and the activity for the year

Master Budget Project

Okay Company is preparing to build its master budget. The budget will detail each quarters activity and the activity for the year in total. The master budget will be based on the following information:

  1. This will be the first year of operation for Okay Company.
  2. Budgeted unit sales by quarter for 2018 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250.
  3. The selling price is $50 per unit. Sales are estimated to be collected 70% in cash and 30% credit.
  4. Of the credit sales, 80% are estimated to be collected in the quarter of the sale and the remaining 20% is collected in the quarter following the sale.
  5. Okays past experience indicates that cost of goods sold is about 60 percent of sales.
  6. Since this is the first year of operations there is no beginning inventory at the beginning of the year. Okays ending inventory policy is 40% of the following quarters inventory needs. Desired ending inventory for 4th Qtr is $74,000.
  7. Okay buys inventory on account. The purchases are paid for in full the quarter following the purchase.
  8. Selling and administrative expenses total $15,000 per quarter, which includes $2,500 depreciation. All selling and administrative expenses requiring cash payments are paid for in the month incurred.

Required: Prepare the following budgets for Okay Company for all 4 quarters and yearly total:

  1. Sales budget
  2. Sales Type
  3. Cash Collections of Sales
  4. Inventory purchases budget
  5. Cash Payments of Inventory
  6. Selling and Administrative expenses budget
  7. Cash Payments of Selling and Administrative expenses
  8. Cash budget

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Research

Authors: David A. Aaker, V. Kumar , George S. Day

8th Edition

047123057X, 9780471230571

More Books

Students also viewed these Accounting questions

Question

Th eir solution was to give me a long-distance number to call.

Answered: 1 week ago