Acct 505 Project 1 Lbj Company

In: Business and Management

Submitted By arnitaetsitty
Words 649
Pages 3
ACCT 505 Project 1 LBJ Company

Click Link Below To Buy:

http://hwaid.com/shop/acct-505-project-1-lbj-company/

COURSE PROJECT 1 INSTRUCTIONS
You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.
You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning. You have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow:
July (actual) 20,000
August (actual) 26,000
September (actual) 40,000
October (budget) 70,000
November (budget) 110,000
December (budget) 60,000
January (budget) 30,000
February (budget) 28,000
March (budget) 25,000 The concentration of sales in the fourth quarter is due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month.

Suppliers are paid $4 for each bracelet. Fifty-percent of a month's purchases is paid for in the month of purchase; the other 50% is paid for in the following month. All sales are on credit with no discounts. The company has found, however, that only 20% of a month's sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.
Monthly operating expenses for the company are given…...

Similar Documents

Acct 505 Project a

...PROJECT A - Case 9-30 Student Name: MacGuyver SALES BUDGET: April May June Quarter Budgeted unit sales 65,000 100,000 50,000 215,000 Selling price per unit $10 $10 $10 $10 Total Sales $650,000 $1,000,000 $500,000 $2,150,000 SCHEDULE OF EXPECTED CASH COLLECTIONS: April May June Quarter February sales $26,000 $26,000 March sales $280,000 $40,000 $320,000 April sales $130,000 $455,000 $65,000 $650,000 May sales $200,000 $700,000 $900,000 June sales $100,000 $100,000 Total Cash Collections $436,000 $695,000 $865,000 $1,996,000 MERCHANDISE PURCHASES BUDGET: April May June Quarter Budgeted unit sales 65,000 100,000 50,000 215,000 Add desired ending inventory 40,000 20,000 12,000 12,000 Total needs 105,000 120,000 62,000 227,000 Less beginning inventory 26,000 40,000 20,000 26,000 Required purchases 79,000 80,000 42,000 201,000 Cost of purchases @ $4 per unit $316,000 $320,000 $168,000 $804,000 BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES: April May June Quarter Accounts payable $100,000 $100,000 April purchases $158,000 $158,000 $316,000 May purchases $160,000 $160,000 $320,000 June purchases $84,000 $84,000 Total cash payments $258,000 $318,000 $244,000 $820,000......

Words: 607 - Pages: 3

Managerial Acct 505 Project a

...PROJECT A - Case 9-30 Accounting 505 Student Name: SALES BUDGET: Budgeted unit sales Selling price per unit Total Sales April 65,000 10 650,000 May 100,000 10 1,000,000 June 50,000 10 500,000 SCHEDULE OF EXPECTED CASH COLLECTIONS: February sales March sales April sales May sales June sales Total Cash Collections 70%, 10% 20%,70%,10% 20%,70% 20% 10% April 26,000 280,000 130,000 May June 40,000 455,000 200,000 695,000 65,000 700,000 100,000 865,000 436,000 MERCHANDISE PURCHASES BUDGET: Budgeted unit sales Add desired ending inventory (40% of next months sales) Total needs Less beginning inventory Required purchases Cost of purchases @ $4 per unit April 65,000 40,000 105,000 26,000 79,000 316,000 May 100,000 20,000 120,000 40,000 80,000 320,000 June 50,000 12,000 62,000 20,000 42,000 168,000 BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES: April Accounts payable 100,000 April purchases 158,000 May purchases June purchases Total cash payments 258,000 May 158,000 160,000 318,000 June 160,000 84,000 244,000 Cash balance Add collections from customers EARRINGS UNLIMITED CASH BUDGET FOR THE THREE MONTHS ENDING JUNE 30 April May 74,000 50,000 436,000 695,000 June 50,000 865,000 Total cash available Less Disbursements Merchandise purchases Advertising Rent Salaries Commissions Utilities Equipment purchases Dividends paid Total Disbursements Excess (deficiency) of receipts over disbursements Financing: Borrowings Repayments Interest Total......

Words: 1365 - Pages: 6

Acct 505 Project B

...000 Part 1 Cash flows over the life of the project Before Tax Tax After Tax Item Amount Effect Amount Annual cash savings $72,540 65% $47,151 Tax savings due to depreciation 32,000 35% $11,200 Total annual cash flow $58,351 Part 2 Payback period $200,000 / $58,351= 3.43 years Part 3 Annual rate of return Accounting income as result of decreased costs Annual cash savings $72,540 Less depreciation 32,000 Before tax income 40,540 Tax at 35% rate 14,189 After tax income $26,351 $26,351 / $200,000 = 13.18% Part 4 Net present value Before Tax After Tax 12% PV Present Item Year Amount Tax % Amount Factor Value Cost of machine 0 -$200,000 -$200,000 1.000 -$200,000 Annual cash savings 1-5 72,540 0.65 47,151 3.605 169,979 Tax savings due to depreciation 1-5 $32,000 0.35 11200 3.605 40,376 Disposal value 5 $40,000 40000 0.567 22,680 Net Present Value $33,035 Part 5 Internal rate of return Excel function method to calculate IRR After Tax Item Year Amount Cost of machine and training 0 -200000 Year 1 inflow 1 58351 Year 2......

Words: 420 - Pages: 2

Acct 505 Course Project

...ACCT505 Part B Course Project B Clark Paints Name: Roosevelt Pollard Data: Cost of new equipment $200,000 Expected life of equipment in years 5 Disposal value in 5 years $40,000 Life production - number of cans 5,500,000 Annual production or purchase needs 1,100,000 Initial training costs 0 Number of workers needed 3 Annual hours to be worked per employee 2,000 Earnings per hour for employees $12.00 Annual health benefits per employee $2,500 Other annual benefits per employee-% of wages 18% Cost of raw materials per can $0.25 Other variable production costs per can $0.05 Costs to purchase cans - per can $0.45 Required rate of return 12% Tax rate 35% Make Purchase Cost to produce $0.30 $0.45 Annual cost of direct material: Need of 1,100,000 cans per year $275,000 $495,000 Annual cost of direct labor for new employees: Wages $72,000 Health benefits $12,960 Other benefits $7,500 Total wages and benefits $92,460 Other variable production costs $55,000 Total annual production costs $422,460 Annual cost to purchase cans $495,000 Part 1 Cash flows over the life of the Equipment INITIAL CASH OUTFLOWS Initial Investments ...

Words: 655 - Pages: 3

Acct 505 Full Week 1

...ACCT 505 Full Week 1 Purchase here http://devrycourse.com/ACCT%20505/acct-505-full-week-1 Product Description ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application ACCT 505 Full Week 1 Purchase here http://devrycourse.com/ACCT%20505/acct-505-full-week-1 Product Description ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application ACCT 505 Full Week 1 Purchase here http://devrycourse.com/ACCT%20505/acct-505-full-week-1 Product Description ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application ACCT 505 Full Week 1 Purchase here http://devrycourse.com/ACCT%20505/acct-505-full-week-1 Product Description ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application ACCT 505 Full Week 1 Purchase here http://devrycourse.com/ACCT%20505/acct-505-full-week-1 Product Description ACCT 505 Week 1 Case...

Words: 325 - Pages: 2

Acct 505 Project B

...Chapter 12 Capital Budgeting Decisions True/False 1. Both the net present value method and the internal rate of return method can be used as a screening tool in capital budgeting decisions. Level: Easy LO: 1 Ans: T 2. When considering a number of investment projects, the project that has the best payback period will also always have the highest net present value. Level: Medium LO: 1,3 Ans: F 3. When discounted cash flow methods of capital budgeting are used, the working capital required for a project is ordinarily counted as a cash outflow at the beginning of the project and as a cash inflow at the end of the project. Level: Medium LO: 1 Ans: T 4. Discounted cash flow techniques automatically provide for recovery of initial investment. Level: Medium LO: 1 Ans: T 5. When computing the project profitability index of an investment project, the investment required will include any investment made in working capital at the beginning of the project. Level: Medium LO: 2 Ans: T 6. If investment funds are limited, the net present value of one project should not be compared directly to the net present value of another project unless the initial investments in these projects are equal. Level: Medium LO: 2 Ans: T 7. In calculating payback where new equipment is replacing old equipment, any salvage value to be received on disposal of the old equipment should be deducted from the cost of the new......

Words: 8346 - Pages: 34

Acct 505 Full Week 1

...ACCT 505 FULL WEEK 1 To purchase this visit following link: http://www.activitymode.com/product/acct-505-full-week-1/ ACCT 505 FULL WEEK 1 ACCT 505 Full Week 1 ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application Activity mode aims to provide quality study notes and tutorials to the students of ACCT 505 Full Week 1 in order to ace their studies. Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 505 FULL WEEK 1 To purchase this visit following link: http://www.activitymode.com/product/acct-505-full-week-1/ ACCT 505 FULL WEEK 1 ACCT 505 Full Week 1 ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and Application Activity mode aims to provide quality study notes and tutorials to the students of ACCT 505 Full Week 1 in order to ace their studies. Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 505 FULL WEEK 1 To purchase this visit following link: http://www.activitymode.com/product/acct-505-full-week-1/ ACCT 505 FULL WEEK 1 ACCT 505 Full Week 1 ACCT 505 Week 1 Case Study 1: Top Switch Inc. ACCT 505 Week 1 Homework P 2-22, P 3-22, E 2-12; E 2-4ACCT 505 Week 1 DQ 1 Cost Terms, Classifications, and Behavior ACCT 505 Week 1 DQ 2 Research and......

Words: 648 - Pages: 3

Acct 505 Project 2 Hampton Company Capital Budgeting Decision

...ACCT 505 Project 2 Hampton Company Capital Budgeting Decision Click Link Below To Buy: http://hwaid.com/shop/acct-505-project-2-hampton-company/ Hampton Company: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years. The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits. It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 50¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 11% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for the company’s products as well as number of units sold will not......

Words: 366 - Pages: 2

Acct 505 Course Project 1

...ACCT 505 Course Project 1 http://homeworklance.com/downloads/acct-505-course-project-1/ COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.You have worked with accounting and other areas to gather the information assembled below. The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow: July (actual) 20,000 August (actual) 26,000 September (actual) 40,000 October (budget) 70,000 November (budget) 110,000 December (budget) 60,000 January (budget) 30,000 February (budget) 28,000 March (budget) 25,000 The concentration of sales in the fourth quarteris due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month. Suppliers are paid $4 for each bracelet. Fifty-percent of a month’s purchases is paid for in the month of purchase; the other 50% is paid for in the following month. All sales are on credit with no discounts. The company......

Words: 645 - Pages: 3

Acct 505 Course Project 1

...ACCT 505 Course Project 1 http://homeworklance.com/downloads/acct-505-course-project-1/ COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.You have worked with accounting and other areas to gather the information assembled below. The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow: July (actual) 20,000 August (actual) 26,000 September (actual) 40,000 October (budget) 70,000 November (budget) 110,000 December (budget) 60,000 January (budget) 30,000 February (budget) 28,000 March (budget) 25,000 The concentration of sales in the fourth quarteris due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month. Suppliers are paid $4 for each bracelet. Fifty-percent of a month’s purchases is paid for in the month of purchase; the other 50% is paid for in the following month. All sales are on credit with no discounts. The company......

Words: 645 - Pages: 3

Acct 505 Course Project 2: Hampton Company

...ACCT 505 Course Project 2: Hampton Company Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acct-505-course-project-2-hampton-company/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Capital Budgeting Decision Hampton Company: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years. The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits. It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 50¢ each if purchased from the current supplier. The company’s minimum rate of return (hurdle rate) has been determined to...

Words: 388 - Pages: 2

Acct 505 Course Project 2: Hampton Company

...ACCT 505 Course Project 2: Hampton Company Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acct-505-course-project-2-hampton-company/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Capital Budgeting Decision Hampton Company: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years. The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits. It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 50¢ each if purchased from the current supplier. The company’s minimum rate of return (hurdle rate) has been determined to...

Words: 388 - Pages: 2

Acct-505 Course Project 1

...ACCT-505 Course Project 1 http://homeworklance.com/downloads/acct-505-course-project-1/ Copy & paste above Link Into your Browser to Buy Tutorial Or Visit: www.homeworklance.com COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.You have worked with accounting and other areas to gather the information assembled below. The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow: July (actual) 20,000 August (actual) 26,000 September (actual) 40,000 October (budget) 70,000 November (budget) 110,000 December (budget) 60,000 January (budget) 30,000 February (budget) 28,000 March (budget) 25,000 The concentration of sales in the fourth quarteris due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month. Suppliers are paid $4 for each bracelet. Fifty-percent of a month’s purchases is paid for in the month of purchase; the......

Words: 660 - Pages: 3

Acct 505 Course Project 1

...ACCT 505 Course Project 1 Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acct-505-course-project-1/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.You have worked with accounting and other areas to gather the information assembled below. The company sells many styles of bracelets, but all are sold for the same $10 price. Actual sales of bracelets for the last three months and budgeted sales for the next six months follow: July (actual) 20,000 August (actual) 26,000 September (actual) 40,000 October (budget) 70,000 November (budget) 110,000 December (budget) 60,000 January (budget) 30,000 February (budget) 28,000 March (budget) 25,000 The concentration of sales in the fourth quarteris due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month. Suppliers are paid $4 for each......

Words: 670 - Pages: 3

Acct 505 Course Project 2: Hampton Company

...ACCT 505 Course Project 2: Hampton Company Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acct-505-course-project-2-hampton-company/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Capital Budgeting Decision Hampton Company: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years. The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits. It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 50¢ each if purchased from the current supplier. The company’s minimum rate of return (hurdle rate) has been determined to...

Words: 388 - Pages: 2