Papst Company is preparing its cash budget for the month of May. The following information is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $ 145,000 $ 181,000 $ 246,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May. 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate requirements 1 and 2 under the assumption that estimated collections in the month of sale equal 60% and in the first month following the month of sale equal 25%. 1. Estimated cash receipts 2. Gross accounts receivable 3. Net accounts receivable 4a. Estimated cash receipts 4b. Gross accounts receivable Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 75,000 75,000 November $ 150,000 $ 67,000 80,400 $ 147,400 December $ 81,000 89,100 $ 170,100 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month's projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are available. Required: 1. Calculate the budgeted total cash receipts for November and December. (Round your final answers to the nearest whole dollar amount.) 2. Calculate budgeted cash disbursements for November and December (budgeted total sales for January of the coming year equals $169,000). 1. Total cash receipts 2. Budgeted cash disbursements November December Easy Clean operates a chain of dry cleaners. It is experimenting with the use of a continuous-improvement (i.e., kaizen) budget for operating expenses. Currently, a typical location has operating expenses of $23,000 per month. Plans are in place to achieve labor and utility savings. The associated operational changes are estimated to reduce monthly operating expenses by a factor of 0.99 beginning in January. Required: What are the estimated operating expenses for January? For June? For December? (Do not round intermediate calculations. Round your final answers to the nearest whole dollar amount.) Estimated operating costs January June December You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 101 units; February, 96 units; March, 103 units; April, 108 units; May, 115 units; June, 123 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 91 units; March, 103 units; April, 103 units; May, 105 units; June, 118 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 98 units; April, 103 units; May, 100 units; June, 118 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 103 units; May, 95 units; June, 108 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 85 units; June, 103 units. In May of the current year, sales for June were reforecasted as 103 units. Actual sales for the six-month period, January through June, were as follows: January, 98 units; February, 91 units; March, 101 units; April, 101 units; May, 113 units; June, 117 units. Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January February March April May < Required 1 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. (Round "Forecast error rate" answers to 2 decimal places. For example, 23.423% = 23.42%.) Actual sales Forecast error rate Direction of error January February March % April % May < Required 1 Required 2 > % June % Show less Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $ 145,000 $ 181,000 $ 246,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May. 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate requirements 1 and 2 under the assumption that estimated collections in the month of sale equal 60% and in the first month following the month of sale equal 25%. 1. Estimated cash receipts 2. Gross accounts receivable 3. Net accounts receivable 4a. Estimated cash receipts 4b. Gross accounts receivable Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 75,000 75,000 November $ 150,000 $ 67,000 80,400 $ 147,400 December $ 81,000 89,100 $ 170,100 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month's projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are available. Required: 1. Calculate the budgeted total cash receipts for November and December. (Round your final answers to the nearest whole dollar amount.) 2. Calculate budgeted cash disbursements for November and December (budgeted total sales for January of the coming year equals $169,000). 1. Total cash receipts 2. Budgeted cash disbursements November December Easy Clean operates a chain of dry cleaners. It is experimenting with the use of a continuous-improvement (i.e., kaizen) budget for operating expenses. Currently, a typical location has operating expenses of $23,000 per month. Plans are in place to achieve labor and utility savings. The associated operational changes are estimated to reduce monthly operating expenses by a factor of 0.99 beginning in January. Required: What are the estimated operating expenses for January? For June? For December? (Do not round intermediate calculations. Round your final answers to the nearest whole dollar amount.) Estimated operating costs January June December You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 101 units; February, 96 units; March, 103 units; April, 108 units; May, 115 units; June, 123 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 91 units; March, 103 units; April, 103 units; May, 105 units; June, 118 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 98 units; April, 103 units; May, 100 units; June, 118 units. In March of the current year, sales for the months April through June were reforecasted as follows: April, 103 units; May, 95 units; June, 108 units. In April of the current year, sales for the months May and June were reforecasted as follows: May, 85 units; June, 103 units. In May of the current year, sales for June were reforecasted as 103 units. Actual sales for the six-month period, January through June, were as follows: January, 98 units; February, 91 units; March, 101 units; April, 101 units; May, 113 units; June, 117 units. Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January February March April May < Required 1 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. (Round "Forecast error rate" answers to 2 decimal places. For example, 23.423% = 23.42%.) Actual sales Forecast error rate Direction of error January February March % April % May < Required 1 Required 2 > % June % Show less
Expert Answer:
Related Book For
Cost Management A Strategic Emphasis
ISBN: 978-0078025532
6th edition
Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Papst Company is preparing its cash budget for the month of May. The following information is available regarding your accounts receivable (based on sales made to customers on open account): March...
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
Calculate the CGT payable in relation to each of the following disposals, assuming in each case that the annual exemption is fully utilised against other gains, that there are no allowable losses and...
-
Using the Yahoo! Finance Web site (finance.yahoo.com) get the current price and five-year dividend history for Eli Lilly & Co. To gather this data, enter the ticker symbol (LLY) in the Get Quotes box...
-
John Lightfoot believes he has a 75 percent chance of earning a bonus of $100. John believes there is a 50 percent chance that his company will pay him the bonus even if he rightfully deserves it....
-
The Howell Corporation has the following account balances (in millions): Prepare an income statement and a supporting schedule of cost of goods manufactured for the year ended December 31, 2017. (For...
-
Lewis Companys standard labor cost of producing one unit of Product DD is 4 hours at the rate of $12.00 per hour. During August, 40,600 hours of labor are incurred at a cost of $12.15 per hour to...
-
Solving via linear equation No unread replies.No replies. A small country exports soybeans and flowers. Soybeans require 8 workers per acre, flowers require 12 workers per acre, and 100,000 workers...
-
Two slender rods of negligible weight are pin-connected at C and attached to blocks A and B, each of weight W. Knowing that P = 1.260W and that the coefficient of static friction between the blocks...
-
Q4: Please find the present value of the following cash flow. t 0 Cash flow $ 27,400,000 1 2 3 96,400,000 12,400,000 20,525,000 Interest rate: Present vale: 45 17,400,000 12,500,000 10% ? Q5:...
-
In the linked - list version of the Stack class, which operations require CONSTANT time for their worst - case behavior? OisEmpty Opop Opush O All of these methods require constant time O
-
Which model can be selected if user is involved in all the phases of Software Development Life Cycle?Prototyping Model a OWaterfall Model b OSpiral model cORapid Application Development Model . . d...
-
Prganisms that can grow at 0 0 c and below are called?
-
Add the following 2's complement binary numbers 01 + 10. Also express the answer in decimal. write the two numbers on one line .and leave space between them 4 :
-
Write a script that deletes all the regular files ( ( not the directories ) ) with a . . js extension that are present in the current directory and all its subfolders.
-
Consider the following polar equation r= 2(cose-sin 0). Show that it can be expressed as (x-1)'+y+1-2.
-
Selected condensed data taken from a recent statement of financial position of Morino Ltd. are as follows. MORINO LTD. Statement of Financial Position (partial) Other current assets...
-
Refer to text Exhibit 10.19 (the ABB for Kerry Window Systems, Inc.). As the management accountant for Kerry you have been asked to evaluate the possibility of implementing a continuous-improvement...
-
HiltonYacht manufactures a line of family cruiser/racing sailboats. The boats are well-known for their quality, safety, and performance. Hilton hired Matthew Perry, a well-known sailboat designer and...
-
Franklin Furniture, Inc. (FFI) manufactures bedroom furniture in sets (a set includes a dresser, two queen-size beds, and one bedside table) for use in motels and hotels. FFI has three customer...
-
Orvil Companys net profit margin percentage is 4.5%, its total asset turnover is 2.4, and its equity multiplier is 1.5. What is the companys return on equity? a. 2.8% b. 7.2% c. 16.2% d. 10.7%
-
Obtain the most recent annual report or SEC filing 10-K of a publicly traded company that interests you. It may be a local company or it may be a company in an industry that you would like to know...
-
Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the...
Study smarter with the SolutionInn App