Using the project budget template, prepare a budget for a project you are involved in.
Project : Pearson Hardman Law consultancy for a 1 month project | ||||
Co-Founders | Contribution in $ | |||
Mike Ross | 2,00,00,000 | |||
Harvey | 4,00,00,000 | |||
Racheal | 1,00,00,000 | |||
Donna | 3,00,00,000 | |||
Total External Income | 10,00,00,000 | |||
Expenses | Amount in $US | |||
Salary specification | ||||
Salaries | Number of employees | Method of cost computation (Hours per week*No. of weeks*$US per hour) | ||
Project staff manager | 40,00,000 | 1 | 4000000 | (10*4*100000) |
Project Co-ordinator | 48,00,000 | 2 | 2400000 | (20*4*30000) |
Administrative staff | 1,60,00,000 | 5 | 3200000 | (40*4*20000) |
Technical/Production staff | 6,00,000 | 1 | 600000 | (5*4*30000) |
Financial Coordinator | - | NA | NA | NA |
Other | - | NA | NA | NA |
Subtotal | 2,54,00,000 | |||
Specialists | ||||
Consultant fees | 10,00,000 | |||
Accountant Costs | 5,00,000 | |||
Bookkeping costs | 2,00,000 | |||
Honoraries of lecturars | 1,00,000 | |||
Translation costs | 50,000 | |||
Others | 1,50,000 | |||
Subtotal | 20,00,000 | |||
PR and printing costs | ||||
Educational Material | 8,00,000 | |||
Prints of material | 3,00,000 | |||
Mailings | 4,40,000 | |||
Advertisments | 9,60,000 | |||
Others | - | |||
Subtotal | 25,00,000 | |||
Travel and accomodation costs | ||||
Travel costs | 8,50,000 | |||
Accomodation costs | 3,50,000 | |||
Hall rent | 3,00,000 | |||
Rent of equipment | 2,00,000 | |||
Transportation | 50,000 | |||
Food and refreshemnt | 4,50,000 | |||
Others | 1,00,000 | |||
Subtotal | 23,00,000 | |||
Other Expenses | ||||
Equipment costs - Laptops, Furniture, VPN network etc.) | 40,00,000 | |||
Rent | 10,00,000 | |||
Material Costs | 5,00,000 | |||
General office stationery | 7,00,000 | |||
Internal, telephone etc | 5,00,000 | |||
Banking fees | 3,00,000 | |||
Tax | 11,00,000 | |||
Insurance | 19,00,000 | |||
Legal fees | 6,00,000 | |||
Miscellaneous | 15,00,000 | |||
Subtotal | 1,21,00,000 | |||
TOTAL EXPENSES | 4,43,00,000 | |||
Reserve Percentage | 35% | |||
Reserve Total | 1,94,95,000 | |||
Total Expense including Reserve | 6,37,95,000 | |||
Using the project budget template, prepare a budget for a project you are involved in. [Co-funder...
In order to get your personal finances under control, you need to prepare a personal budget. Assume that you have compiled the following information regarding your expected cash flows for a typical month. $210 Rent payment Interest income Income tax withheld Electricity bill Groceries Wages earned Insurance $500 Miscellaneous costs 50 Savings 300 Eating out 85 Telephone and Internet costs 100 Student loan payments 2,500 Entertainment costs 100 Transportation costs 150 125 375 250 150 Using the information above, prepare...
Use the following information to prepare the September cash budget for PTO Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. a. Beginning cash balance, September 1, $42,000. b. Budgeted cash receipts from sales in September, $255,000. c. Raw materials are purchased on account. Purchase amounts are August (actual), $77,000, and September (budgeted) $107,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in...
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 Plastic 90 lb Foam lining 80 lb Finished pducts Batting...
1) bomar imorgan x > Project Management in Practice x + 532 Project Management in_Practice_6th_6bf4.pdf C A SE Friendly Assisted Living Facility Project Budget Development-4 Fred Splient gave his ALF Project Steering Committee 2 months to develop a project plan for their area of respon sibility in the project. Each member was told to include the tasks predecessors and successors, resources needed, responsible person, and an estimated cost. He asked that these be presented to the steering team on August...
I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and sells high quality certified sustainable coffee beans. The final one pound bags of roasted whole coffee beans has two direct materials – coffee beans and packaging. GBCoffee is preparing budgets for the fourth quarter ending December 31, 2019. For each requirement below prepare budgets by month for October, November, and December, and a total budget for the quarter. 1. The previous year’s sales for...
You have been selected as the project manager for the Global Treps project. You helped to run a local shark tank like event at your college last year as part of a class project, so you have a general idea of what is involved. The schedule goal is six months, and the budget is $120,000. Your favorite professor, Dr. K., and a few of her associates have agreed to fund the project. Your strengths are your organizational and leadership skills....
Using the budget project you just completed, create a
PowerPoint or Word Document presentation that will serve as an
executive brief to the organization's leadership team. The
presentation should include an overview of the budgets and the
process for creating the budgets.
1. Briefly summarize each department budget and note
any large variances.
2. Explain two variances that might cause concern or prompt further
analysis.
3. Create an executive briefing presentation in which you briefly
summarize all budgets. Include all...
plz answer the questions at the bottom
1) bomar imorgan x > Project Management in Practice x + 532 Project Management in_Practice_6th_6bf4.pdf C A SE Friendly Assisted Living Facility Project Budget Development-4 Fred Splient gave his ALF Project Steering Committee 2 months to develop a project plan for their area of respon sibility in the project. Each member was told to include the tasks predecessors and successors, resources needed, responsible person, and an estimated cost. He asked that these be...
Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells a single model The unit cost for ending FG inventory at 12/31/11 was $374.80. of snowboard, the Vortex. In the summer of 2011, Ignore Work In Process Iggy Sawdust, CPA, provided data for the 2012 budget: Direct Material Requirements (per snowboard) The December 2012 Budget Includes the following selected balances: Wood 5 board feet (b.f.) Cash $ 10,000.00 Fiberglass 6 yards Property, Plant, and Equipment...
Could you do letter D. Direct labor budget
Comprehensive Budget Project 2a Confluence Backpacks Manufacturing Confluence Backpacks Manufacturing produces nylon backpacks and larger packs to sell to tourists visiting the Western United States and other tourist areas. The design of the two products is unique and represents a breakthrough in the industry. The company is completing its eighth year of operations and is preparing to build its master budget for the coming year, 2019. The budget will detail each quarter's...