Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please only do requirement 8-9! Thank you! Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the
Please only do requirement 8-9! Thank you!
Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information: This will be the first year of operation for Okay Company Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,500, Second quarter 6,000. Third quarter 6.100 & Fourth quarter 6,250. The selling price is $50 per unit. Sales are estimated to be collected 70% in cash and 30% credit. +' 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. Okay's past experience indicates that cost of goods sold is about 60 percent of sales. Since this is the first year of operations there is no beginning inventory at the beginning of the year Okay's ending inventory policy is 40% of the following quarter's inventory needs Okay buys inventory on account. The purchases are paid for in full the quarter following the purchase 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. a. b. c. d. e. f. g. +' h. +' Required: Prepare the following budgets for Okay Company:* 1 (4 points) Sales budget for all 4 quarters and yearly total. 2. (4 points) Sales Type for 1st and 2ad quarters..* 3 (4 points) Cash Collections of Sales for 1st and 2nd quarters. 4. (4 points) Inventory purchases budget for 1st and 2nd quarters. 5. (4 points) Cash Payments of Inventory for 1st and 2nd quarters.* 6. (4 points) Selling and Administrative expenses budget for 1st and 2nd quarters.* 7. (4 points) Cash Payments of Selling and Administrative expenses for 1st and 2ad quarters.* 8. (4 points) Cash budget for 1st and 2nd quarters. 9. (4 points) Calculate 2nd quarter ending Cash Balance if 1st quarters Sales Units is changed to 6,000 10. (6 points) For correct formulas in the excel spreadsheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started