4-6) (Cash budget) The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $ 90,000 February 120,000 March 135,000 April 240,000 May $300,000 June 270,000 July 225,000 August 150,000 Of Sharpe's sales, 10 percent is for cash, another 60 percent is collected in the mo
Given the new details below to do the following: · Construct a quarterly cash budget for Lawrence · Tell me what is the largest amount of bank debt needed and when is it needed · Circle them in the on the borrowing line of the matrix · What is the largest amount of surplus cash flow generated by Lawrence and when doe
Please see attached file. . From PE 22-1A what is the total department costs? ( $110,000 $130,000 $180,000 None of the above 8. From PE 22-2A what is the total units to be produced? 235,000 216,000 231,000 None of the above 9. From PE 22
1. Explain the difference between a traditional income statement and a contribution margin income statement by providing the following three items: *present a sample format for each statement *describe the focus of each statement *discuss how and by whom each statement is used 2. Your company acquires production equipmen
2. The Merry Christmas Gift Shoppe has forecast its sales revenues and purchases for the last 5 months of 2008 to be as follows: Sales Purchases August $22,000 $17,000 September 15,000 19,500 October 25,000 29,000 November 30,000 20,000 December 26,000 24,000 60% of sales are on credit. On the basis of past experie
See attached file All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for the following
Prepare a cash budget for Rotor Products, Inc. for the second quarter of 2006, based on the following. All are for cash: Total Sales March 2006 (actual) 425,000 April 2006 330,000 May, 2006 420,000 June, 2006 450,000 The company estimates its purchases
The following information is budgeted for Jana supply company for the next quarter: April May June Sales $110,000 $130,000 $180,000 Merchandise purchases $85,000 $92,000 $105,000 Selling and administrative
Please see attached file. The Airhart Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $190,000 $78,000 $34,000 February
Accounts receivable, May 31: (.3 x May sales of $450,000) = $135,000. Monthly forecasted sales: June, $400,000; July, $440,000; August, $500,000; September, $530,000. Sales consist of 70% cash and 30% credit. All credit accounts are collected in the month following the sales. Uncollected accounts are negligible and may be i
Prepare a master budget for the following: Victoria kite Company, a small Melbourne firm that sells kites on the web wants a master budget for the next three months, beginning January 1, 2008. It desires an ending minimum cash budget of $ 5,000 each month. Sales are forecast at an average wholesale selling price of $ 8 per
See attach word document and excel file. Wilma Brown, treasurer of Columbia Civic Theater (CCT), was preparing a loan request to the Northeast National Bank in December 2004. The loan was necessary to meet the cash needs of the theater for year 2005. In a few short years, the CCT had established itself as a premier theater. I
23. Cash Budget. The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $30 and total sales in January were $180
Question: Davis Corporation is preparing its Manufacturing Overhead Budget for the fourth quarter of the year. The budgeted variable factory overhead rate is $1.8 per direct labor-hour; the budgeted fixed factory overhead is $117,000 per month, of which $30,000 is factory depreciation. If the budgeted direct labor time for No
The Bandeiras Company, a merchandising firm, has budgeted its activity for December according to the following information: - Sales at $560,000, all for cash. - Merchandise inventory on November 30 was $303,000. - Budgeted depreciation for December is $38,000. - The cash balance at December 1 was $30,000. - Selling and ad
Question 6: Cartier Inc. bases its manufacturing overhead budget on budgeted direct labor-hours. The variable overhead rate is $5.2 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $40,330 per month, which includes depreciation of $12,370. All other fixed manufacturing overhead costs represent cu
Question 2: Pitkins Company collects 17% of a month's sales in the month of sale, 65% in the month following sale, and 14% in the second month following sale. The remainder is uncollectible. Budgeted sales for the next four months are: January February March April Budgeted sales $202,000 $303,000 $353,000 $2
State what additional assumptions and information that you would need to prepare a cash budget.
Preparation of cash budgets (for three periods) See pdf attached Question 2: (10 points) Problem 7-2A: Preparation of cash budgets (for three periods) L.O. C3, P2 During the last week of August, Oneida Company's owner approaches the bank for an $100,000 loan to be made on September 2 and repaid on November 30 with annua
Budgeting Your task is to make a master budgeting template in a spreadsheet. Obtain the pre-formatted spreadsheet (master.xls). The information necessary for making the master budget is given in Part I of the spreadsheet. You need to enter formulas in Part II. Once you enter all required formulas, you can use this mas
1. The budget projects cash inflows and outflows and the end of period balance sheet. a. Cash. b. Financial. c. Capital expenditures d. purchases 2. CVP analysis assumes that the ONLY factor that affects costs in change in volume. True False 3. Total Fixed Costs $15,000 Sale Price per Unit $23 Variable Cost
What is the main reason for preparing a cash budget in the master budgeting process? What additional steps need to be taken for seasonal businesses to ensure an optimal outcome? What are the risks associated with inaccuracies in preparing the pro forma income statement and cash budget?
To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a Cash Budget for his latest venture- Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next nine months: March 2004: $250,000 April: 275,000
Directions: define each of the budgets listed and briefly describe its uses. 1.Sales budget 2.Production budget 3.Direct materials budget 4.Direct labor budget 5.Manufacturing overhead budget 6.Selling and administrative expense budget 7.Budgeted income statement 8.Cash budget
4-6A. (Cash budget) The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows: January $ 90,000 May $300,000 February 120,000 June 270,000 March 135,000 July 225,000 April 240,000 August 150,000 Of Sharpe's sales, 10 percent is for cash, another 60 percent is collected in the month foll
The budgeted prices for materials and direct labor per unit of finished product are $11 and $55, respectively. The production manager is delighted about the following data: The budgeted prices for materials and direct labor per unit of finished product are $11 and $55, respectively. The production manager is delighted ab
Sales and Production Budgets The marketing department of Graber Corporation has submitted the following sales forecast for the upcoming fiscal year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales..................... 16,000 15,000 14,000 1
Please see the attached file. 04. The budget director of Flory's Kitchen Shop has prepared the following sales budget. The company had $100,000 of accounts receivable at January 1. The company normally collects 100 percent of its accounts receivable in the month following the sale. Required: (a) Complete the schedule
Prepare a Master Budget, on Excel, as described in the attachment. The CELLO Company wants a Master Budget for the next three months beginning January 1, 2009. It desired an ending minimum cash balance of $4000 each month. Sales are forecasted at average selling prices of $4 per unit. Inventories are supposed to equal 125%
See attachment. I need help with problems 26.7,26.14,27.8 and 28.10. 26.7 Indicate whether the following company actions increase, decrease, or cause no change to the cash cycle and the operating cycle. a. The use of discounts offered by suppliers is decreased. b. More finished goods are being produced for orders in