Electro Company manufactures an Innovative automobile transmission for electric cars. Management predicts that ending finished goods Inventory for the first quarter will be 191,200 units. The following unit sales of the transmisslons are expected during the rest of the year: second quarter, 478,000 units; third quarter, 452,000 units; and fourth quarter, 288,500 units. Company policy calls for the ending finished goods inventory of a quarter to equal 40% of the next quarter's budgeted sales. Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture. ELECTRO COMPANY Production Budget Second and Third Quarters Second Quarter Third Quarter Required units of available production Units to be produced
Q: Packer Company expects to sell 4,500 units for $180 each for a total of $810,000 in January and…
A:
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: Budgeted balance sheet and income statement provides forecast about the estimated profitability and…
Q: NUBD Corp, plans to sell 200,000 units of LIB product in July and anticipate a growth in sales of 7%…
A: Given information, Sales in july =200,000 units Growth of sales =7% per month Ending inventory = 80%…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Ming Company has budgeted sales at 6,300 units for the next fiscal year, and desires to have 590…
A: Total units to be produced = Total units produced before allowing scrap /(100% - 10%) =…
Q: A corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: •…
A: Cash Budget- It is used to know the requirement of cash in coming time so that neccesary adjustment…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: Budgeting is the estimation done by the organization for the current year on the basis of past…
Q: One Device makes universal remote controls and expects to sell 764 units in January, 960 in…
A: The production budget is prepared to estimate the production required during period.
Q: Rocker Company expects to sell 7,000 units for $180 each for a total of $1,260,000 in January and…
A: A budget is an estimate of incomes and expenditures of an organization over a period of time.
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: Delsing Plumbing Company has beginning inventory of 24,000 units, will sell 70,000 units for the…
A: Given Beginning Inventory = 24,000 units Sell = 70,000 units Ending Inventory = 40% of Beginning…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: Cash budget in the business shows all expected cash receipts and expected cash payments that are to…
Q: Cahuilla Corporation predicts the following sales in units for the coming four months: April May…
A: The inventory that a business must buy throughout each budget period is included in a purchases…
Q: Ultravision Inc. anticipates sales of $460,000 from January through April. Materials will represent…
A: Cashflows means movement of cash, it can be positive or negative. Positive cashflows means cash…
Q: Walsh Company expects sales of Product W to be 60,000 units in April, 75,000 units in May and 70,000…
A: Step 1 Productivity simply refers to the measurement of how efficient a company's production process
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Direct material closing inventory should be 30% of next months production units needed Direct…
Q: Company expects sales of Product F to be 59,000 units in April, 75,000 units in May and 70,000 units…
A: Estimated Production = Estimated Sales + Ending inventory - Beginning inventory
Q: how would i find the total cash reciepts for this problem
A: Determine sales revenue for each month.
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: Hi studentSince there are multiple subparts, we will answer only first three subparts. If you want…
Q: Cahuilla Corporation predicts the following sales in units for the coming four months: April May…
A: The number of units of product that must be manufactured is defined by the production budget, which…
Q: Shadee Corp. expects to sell 550 sun visors in May and 310 in June. Each visor sells for $16.…
A: Sales revenue = Number of units sold x selling price per unit.
Q: IRWIN TECH sales in June were 400,000 units. Sales are expected to increase by 2% each month during…
A: Material Budget: It budgets how much raw materials the company requires to meet budgeted…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: The Schedule of expected collections is a statement that contains details of the estimated cash that…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: The question is based on the concept of Budget costing.
Q: Cahuilla Corporation predicts the following sales in units for the coming four months: April May…
A: Working:
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Operating budgets: These are the statements that show the projected expenses and revenues of an…
Q: Bear, Inc. estimates its sales at 200,000 units in the first quarter and that sales will increase by…
A: Production for any specific period = Sales units + Ending finished goods - Beginning finished goods
Q: Prepare a production budget for the first quarter of the year. Show the number of drums that should…
A: Hi student Since there are multiple questions, we will answer only first question.
Q: Trevor Company expects sales of Product W to be 62,000 units in April, 77,000 units in May, and…
A: Desired ending inventory for April = Budgeted sales for May x 40% = 77000*40% = 30800 units
Q: Offenbach & Son has just made its sales forecasts and its marketing department estimates that the…
A: Budgeted production in units will be equal to estimated sales plus desired ending inventory minus…
Q: Rocker Company expects to sell 7,000 units for $180 each for a total of $1,260,000 in January and…
A: Budgeted cost of goods sold in March = 4,300 * $260 * 60%= $670,800
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: working notes: 1. Cash will be: this amount has been taken from the cash budget i.e. from Cash =…
Q: The current inventory of blue rugs is 60,000 units and management would like to see an increase of…
A: Working Notes: 1. material rate per unit = cotton + canvas = (1 yard *$3*120%) + (0.2 yard*$10) = $…
Q: The Volt Battery Company has forecast its sales in units as follows: January 1,100 February…
A: The manufacturing company needs materials, labor, and expenses for the production process. Thus, the…
Q: Forrest Company manufactures phone chargers and has a JIT policy that ending inventory should equal…
A: Production budget: It reflects the number of units of the goods that should be manufactured by the…
Q: Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: This question deals with the preparation of schedules of expected cash collection, purchase budget…
Q: A large St. Louis feed mill, Robert Orwig Processing,prepares its 6-month aggregate plan by…
A: Production Plan is a budget created by a manufacturing firm to account for the expenditures to be…
Q: The controller of Fortnight Co. has requested a quick estimate of the manufacturing supplies needed…
A: The high low method is used to find the variable and fixed cost of the production from the mixed…
Q: Sohar Company. estimates its sales at 180,000 units in the first quarter and that sales will…
A: A manufacturing company is a business that is focused on the production of goods to the customers as…
Q: Crawford Steel Corp. buys inventory of 40,000 units annually. The purchase price per unit is $3.00…
A: Inventory Management: Inventory management tools like the economic order quantity, the reorder level…
Q: One Device makes universal remote controls and expects to sell 526 units in January, 575 in…
A: Production budget shows how many units needs to be produced for desired sales and maintaining the…
Q: Shadee Corp. expects to sell 570 sun visors in May and 310 in June. Each visor sells for $15.…
A: Calculation of estimated cash receipts from cash sales and credit sales is very important section of…
Q: Jarash, Inc. anticipates sales of 121758 units, 150,000 units and 160.000 units in July. August, and…
A: The units production in July can be estimated from the cost of goods sold equation
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: "Since you have posted a question with multiple sub parts, we will solve first three sub parts for…
Q: Preston anticipates selling 223,000 jars with total sales revenue of $267,000 in the first quarter…
A: The production budget is prepared to determine the number of units to be produced in the future to…
Q: Ajax Manufacturing produces a single product, which takes 8.0 pounds of direct material per unit…
A: Budgeting is used to analyze and evaluate the future situation. basically it is based on past…
Q: Douglas Company plans to sell 24,000 units of Product A during July and 30,000 units during August.…
A: In order to determine the no. of units required to be produced, the desired ending inventory is…
Q: Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data…
A: Income statement is prepared to show the net income of the organisation during the accounting…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March 2016: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lbs. Batting helmet........ 40 units at 25 per unit Foam lining 80 lbs. Football helmet....... 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic50 lbs. Batting helmet......... 50 units at 25 per unit Foam lining65 lbs. Football helmet........ 220 units at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lbs. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lbs. per unit of product Foam lining 1.50 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventor) of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department 1.80 hrs. at 14 per hr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2,300 h. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expense-selling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- Budgeted income statement and supporting budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof product Plastic . . 0.50 lb. per unit of product Plastic 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income .statement for March: a. Estimated sales for March: Batting helmet 1,200 units at 40 per unit Football helmet 6,500 units at 160 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Plastic 90 lb. Batting helmet 40 units at 25 per unit Foam lining 80 lb. Football helmet 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic 50 lb. Batting helmet 50 units at 25 per unit Foam lining 65 lb. Football helmet 220 its at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lb. per unit of product Foam lining 1.50lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department l.80 hrs.at 14perhr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2300 h. Estimated operating for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 i. Estimated other income and expense for March: Interest Revenue 940 Interest Expense 872 j. Estimated tax rate: 30% Instructions 1.Prepare a sales budget for March. 2.Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7.Prepare a selling and administrative expenses budget for March. 8.Prepare a budgeted income statement for March. 9.Prepare a factory overhead cost budget for March. 10.Prepare a cost of goods .sold budget for March. Work in process at the beginning of March is estimated to the 115,300, and work in process at the end of March is desired to be 14,800. 11.Prepare a selling and administrative expenses budget for March. 12.Prepare a budgeted income statement for March.Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows: A. Estimated sales for July by sales territory: Maine: Backyard Chef............................. 310 units at 700 per unit Master Chef............................... 150 units at 1,200 per unit Vermont: Backyard Chef............................. 240 units at 750 per unit Master Chef............................... 110 units at 1,300 per unit New Hampshire: Backyard Chef............................. 360 units at 750 per unit Master Chef............................... 180 units at 1,400 per unit B. Estimated inventories at July 1: Direct materials: Finished products: Grates..................... 290 units Backyard Chef........ 30 units Stainless steel.............. 1,500 lbs. Master Chef........... 42 units Burner subassemblies...... 170 units Shelves.................... 340 units C. Desired inventories at July 31: Direct materials: Finished products: Grates......................... 340 units Backyard Chef........ 40 units Stainless steel.................. 1,800 lbs. Master Chef........... 20 units Burner subassemblies.......... 155 units Shelves........................ 315 units D. Desired materials used in production In manufacture of Backyard Chef: Grates........................................ 3 units per unit of product Stainless steel................................. 24 lbs. per unit of product Burner subassemblies......................... 2 units per unit of product Shelves....................................... 4 units per unit of product In manufacture of Master Chef: Grates........................................ 6 units per unit of product Stainless steel................................. 42 lbs. per unit of product Burner subassemblies......................... 4 units per unit of product Shelves....................................... 5 units per unit of product E. Anticipated purchase price for direct materials: Grates................. 15 per unit Stainless steel.......... 6 per lb. Burner subassemblies...... 110 per unit Shelves.................... 10 per unit F. Desired labor requirements: Backyard Chef: Stamping Department...................... 0.50 hr. at 17 per hr. Forming Department....................... 0.60 hr. at 15 per hr. Assembly Department...................... 1.00 hr. at 14 per hr. Master Chef: Stamping Department...................... 0.60 hr. at 17 per hr. Forming Department....................... 0.80 hr. at 15 pr hr. Assembly Department...................... 1.50 hrs. at 14 per hr. Instructions 1. Prepare a sales budget for July. 2. Prepare a production budget for July. 3. Prepare a direct materials purchases budget for July. 4. Prepare a direct labor cost budget for July.
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.Forecast sates volume and sales budget For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 20Y9, unit sales are expected to Follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" the frame is expected to Increase to 17 and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31,. 20Y8, Over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 51. 20Y9.
