Question

In: Accounting

Operating Budget • Review 1: Purchase Budget and Cash Collections • Capes Corporation is a wholesaler...

Operating Budget
• Review 1: Purchase Budget and Cash Collections
• Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations
• follow:
• · Sales are budgeted at $390,000 for November, $360,000 for December, and $340,000 for January.
• · Collections are expected to be 85% in the month of sale, 10% in the month following the sale, and 5%
uncollectible.
• · The cost of goods sold is 80% of sales.
• · The company purchases 40% of its merchandise in the month prior to the month of sale and 60% in the
month of sale. Payment for merchandise is made in the month following the purchase.
• · The November beginning balance in the accounts receivable account is $77,000.
• · The November beginning balance in the accounts payable account is $320,000.
• Required:
• a. Prepare a Schedule of Expected Cash Collections for November and December.
• b. Prepare a Merchandise Purchases Budget for November and December

Unit Purchase Budget
A sales budget is given below for one of the products manufactured by the Key Co.:
January.................. 21,000 units
February................ 36,000 units
March.................... 61,000 units
April...................... 41,000 units
May....................... 31,000 units
June....................... 25,000 units
The inventory of finished goods at the end of each month should equal 20% of the next month's sales. However, on December 31
the finished goods inventory totaled only 4,000 units.
Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key's
suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to
30% of the next month's production needs. This requirement had been met on January 1 of the current year.
Required: Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March and in
total for the quarter.

Simple Rate of Return
• (Ignore income taxes in this problem.)
• Ducey Corporation is contemplating purchasing equipment that would increase sales revenues by
$79,000 per year and cash operating expenses by $27,000 per year. The equipment would cost
$150,000 and have a 6 year life with no salvage value. The annual depreciation would be
$25,000.
• Required: Determine the simple rate of return on the investment to the nearest tenth of a percent.
Show your work.

Solutions

Expert Solution

Operating Budget:

Requirement a:
Schedule of Expected Cash Collections:
November December
A Budgeted Sales $390,000 $360,000
B Cash Collections:
   Accounts Receivable at the beginning of November $77,000
   85% in the month of Sale (85% of A) $331,500 $306,000
   10% in the month following the sale (10% of Nov A) $39,000
$408,500 $345,000
Requirement b:
Merchandise Purchases Budget:
November December January
A Budgeted Sales $390,000 $360,000 $340,000
B Cost of Goods Sold (80% of A) $312,000 $288,000 $272,000
C Budgeted Purchases
   40% in the month prior to month of sale (40% of next month B) $115,200 $108,800
   60% in the month of sale (60% of B) $187,200 $172,800
$302,400 $281,600

Related Solutions

1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the...
1) Sales Budget and Expected Cash Collections The marketing department of Alex Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following...
1)        Sales Budget and Expected Cash Collections The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,000 12,000 14,000 13,000 The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The...
Building the Master Budget involve: The Sales Budget. The Production Budget Expected Cash Collections Budget The Direct Materials Budget Expected Cash Disbursement Budget The Direct Labor Budget Manufacturing Overhead Budget Ending Finished Goods Inventory Budget Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet Full Explanations
Review the information presented below in the Sample Operating Budget and adjust this budget according to...
Review the information presented below in the Sample Operating Budget and adjust this budget according to the following: You have just learned that inpatient charges will probably be 3% higher than projected and that outpatient charges are expected to increase by 8%, and that your research grant support will be reduced by half. The continuing education conference projected to net $3,200 has been canceled. Salary expenses will likely be 2% higher than originally anticipated. You are required to show a...
LockUp Corporation has the following items in the Petty Cash and Cash Collections combined as of...
LockUp Corporation has the following items in the Petty Cash and Cash Collections combined as of as of January 5, 2020 during the checking of Cash for December 31, 2019 balance sheet. a.    Bills and Coins Denomination Bundle of 100 pcs Rolls of 50 coins Loose P 500 1 9 100 2 27 50 3 5 20 5 4 10 10 5 6 4 1 10 20 .25 40 16 b.    Checks Maker Payee Date Amount Baran - Customer LockUp 12/30/2019 P...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
1- What information is provided in the operating cash receipts portion of the cash budget? 2...
1- What information is provided in the operating cash receipts portion of the cash budget? 2 - What information is provided in the operating cash payments portion of the cash budget? 3 - Describe the use of Pivot Tables in Excel. Cite 2 examples of how Pivot Tables can be used in decision making by management. 4 - How can financial ratios help to identify the financial strength of a company? Give at least 2 examples of financial ratios that...
Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections...
Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections in quarter of sale Collections in quarter following sale Total cash available Payments in quarter of purchase Payments in quarter following purchase Direct labor Overhead Selling and Administrative expense Equipment purchases Dividends Total Cash Disbursements Net cash balance Minimum cash balance Excess (Deficiency) of cash Cash balance before interest on balance Interest earned on cash balance Cash balance after interest on balance Diesel Dynamo...
Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the...
Problem 18-10 Calculating Cash Collections The following is the sales budget for Shleifer, Inc., for the first quarter of 2017: January February March Sales budget $ 215,000 $ 235,000 $ 258,000    Credit sales are collected as follows:    55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale.    The accounts receivable balance at the end of the previous quarter was $99,000 ($69,000 of...
What are the components of the operating Budgets? How are the operating budgets, cash budget, and...
What are the components of the operating Budgets? How are the operating budgets, cash budget, and budgeted balance sheet interrelated?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT