Free Essay

Spreadsheet Assignment 1

In:

Submitted By janher12
Words 1814
Pages 8
Annual Cash Budget - Year 1 Assumptions January February March April May June July August September October November December
Sales 100% 22,814 24,399 25,984 27,569 30,769 32,324 35,494 38,664 38,664 32,324 29,154 25,984
Cash Inflows: 364,143 6.27% 6.70% 7.14% 7.57% 8.45% 8.88% 9.75% 10.62% 10.62% 8.88% 8.01% 7.14% Cash 22,814 24,399 25,984 27,569 30,769 32,324 35,494 38,664 38,664 32,324 29,154 25,984 Loan Proceeds 175,000
Total Inflows: 197,814 24,399 25,984 27,569 30,769 32,324 35,494 38,664 38,664 32,324 29,154 25,984 Cash Outflows: Purchases 38.00% 8,669.32 9,271.62 9,873.92 10,476.22 11,692.22 12,283.12 13,487.72 14,692.32 14,692.32 12,283.12 11,078.52 9,873.92 Salaries and Wages 12 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 Employee Related Expenses 15% 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 Direct Operatings Expesnes 3.60% 821 878 935 992 1,108 1,164 1,278 1,392 1,392 1,164 1,050 935 Utilities & Telephone 3.40% 776 830 883 937 1,046 1,099 1,207 1,315 1,315 1,099 991 883 Property Insurance 1.50% 342 366 390 414 462 485 532 580 580 485 437 390 Admin Expenses 1.70% 388 415 442 469 523 550 603 657 657 550 496 442 Repairs & Maint 1.00% 228 244 260 276 308 323 355 387 387 323 292 260 Advertising & Promotion 2.00% 456 488 520 551 615 646 710 773 773 646 583 520 Property & Related Taxes 2.20% - 1,610 1,995 2,482 Start Up Expenses 4,678 4,678 Initial Inventory 5,322 5,322 Equipment 5,000 5,000 Building 160,000 160,000 Loan Pymt $1,836.20 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 Total Outflows: 197,413 23,225 24,036 26,458 26,486 27,282 30,900 30,528 30,528 29,764 25,659 24,036 Beginning Cash Balance 5,000 5,000 5,401 6,575 8,523 9,635 13,918 18,959 23,554 31,690 39,825 42,385 45,880 Add: Inflows 197,814 24,399 25,984 27,569 30,769 32,324 35,494 38,664 38,664 32,324 29,154 25,984 Subract: Outflows 197,413 23,225 24,036 26,458 26,486 27,282 30,900 30,528 30,528 29,764 25,659 24,036 Ending Cash Balance 5,401 6,575 8,523 9,635 13,918 18,959 23,554 31,690 39,825 42,385 45,880 47,828 Less: Minimum Cash 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Surplus (Deficit) (9,599) (8,425) (6,477) (5,365) (1,082) 3,959 8,554 16,690 24,825 27,385 30,880 32,828

Annual Cash Budget - Year 2 Assumptions January February March April May June July August September October November December
Sales 110% 25,095.40 26,838.90 28,582.40 30,325.90 33,845.90 35,556.40 39,043.40 42,530.40 42,530.40 35,556.40 32,069.40 28,582.40
Cash Inflows: 400,557.30 6.27% 6.70% 7.14% 7.57% 8.45% 8.88% 9.75% 10.62% 10.62% 8.88% 8.01% 7.14% Cash 25,095 26,839 28,582 30,326 33,846 35,556 39,043 42,530 42,530 35,556 32,069 28,582 Loan Proceeds
Total Inflows: 25,095 26,839 28,582 30,326 33,846 35,556 39,043 42,530 42,530 35,556 32,069 28,582 Cash Outflows: Purchases 38.00% 9,536.25 10,198.78 10,861.31 11,523.84 12,861.44 13,511.43 14,836.49 16,161.55 16,161.55 13,511.43 12,186.37 10,861.31 Salaries and Wages 12 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 Employee Related Expenses 15% 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 Direct Operatings Expesnes 3.60% 903 966 1,029 1,092 1,218 1,280 1,406 1,531 1,531 1,280 1,154 1,029 Utilities & Telephone 3.40% 853 913 972 1,031 1,151 1,209 1,327 1,446 1,446 1,209 1,090 972 Property Insurance 1.50% 376 403 429 455 508 533 586 638 638 533 481 429 Admin Expenses 1.70% 427 456 486 516 575 604 664 723 723 604 545 486 Repairs & Maint 1.00% 251 268 286 303 338 356 390 425 425 356 321 286 Advertising & Promotion 2.00% 502 537 572 607 677 711 781 851 851 711 641 572 Property & Related Taxes 2.20% 1,924 1,771 2,194 2,730 Inventory 532.20 44 44 44 44 44 44 44 44 44 44 44 44 Loan Pymt $1,836.20 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 Total Outflows: 25,550 24,518 25,411 28,075 28,106 28,981 32,961 32,552 32,552 31,712 27,196 25,411 Beginning Cash Balance 47,828 47,374 49,695 52,866 55,117 60,858 67,432 73,515 83,493 93,472 97,316 102,189 Add: Inflows 25,095 26,839 28,582 30,326 33,846 35,556 39,043 42,530 42,530 35,556 32,069 28,582 Subract: Outflows 25,550 24,518 25,411 28,075 28,106 28,981 32,961 32,552 32,552 31,712 27,196 25,411 Ending Cash Balance 47,374 49,695 52,866 55,117 60,858 67,432 73,515 83,493 93,472 97,316 102,189 105,361 Less: Minimum Cash 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Surplus (Deficit) 32,374 34,695 37,866 40,117 45,858 52,432 58,515 68,493 78,472 82,316 87,189 90,361

Annual Cash Budget - Year 3 Assumptions January February March April May June July August September October November December
Sales 110% 27,604.94 29,522.79 31,440.64 33,358.49 37,230.49 39,112.04 42,947.74 46,783.44 46,783.44 39,112.04 35,276.34 31,440.64
Cash Inflows: 440,613.03 6.27% 6.70% 7.14% 7.57% 8.45% 8.88% 9.75% 10.62% 10.62% 8.88% 8.01% 7.14% Cash 27,605 29,523 31,441 33,358 37,230 39,112 42,948 46,783 46,783 39,112 35,276 31,441 Loan Proceeds
Total Inflows: 27,605 29,523 31,441 33,358 37,230 39,112 42,948 46,783 46,783 39,112 35,276 31,441 Cash Outflows: Purchases 38.00% 10,489.88 11,218.66 11,947.44 12,676.23 14,147.59 14,862.58 16,320.14 17,777.71 17,777.71 14,862.58 13,405.01 11,947.44 Salaries and Wages 12 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 7,736 Employee Related Expenses 15% 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 1,160.35 Direct Operatings Expesnes 3.60% 994 1,063 1,132 1,201 1,340 1,408 1,546 1,684 1,684 1,408 1,270 1,132 Utilities & Telephone 3.40% 939 1,004 1,069 1,134 1,266 1,330 1,460 1,591 1,591 1,330 1,199 1,069 Property Insurance 1.50% 414 443 472 500 558 587 644 702 702 587 529 472 Admin Expenses 1.70% 469 502 534 567 633 665 730 795 795 665 600 534 Repairs & Maint 1.00% 276 295 314 334 372 391 429 468 468 391 353 314 Advertising & Promotion 2.00% 552 590 629 667 745 782 859 936 936 782 706 629 Property & Related Taxes 2.20% 2,117 1,949 2,413 3,003 Inventory 585.42 49 49 49 49 49 49 49 49 49 49 49 49 Loan Pymt $1,836.20 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 1,836 Total Outflows: 27,031 25,897 26,879 29,809 29,843 30,806 35,184 34,734 34,734 33,810 28,843 26,879 Beginning Cash Balance 105,361 105,935 109,561 114,123 117,672 125,060 133,365 141,129 153,179 165,228 170,530 176,964 Add: Inflows 27,605 29,523 31,441 33,358 37,230 39,112 42,948 46,783 46,783 39,112 35,276 31,441 Subract: Outflows 27,031 25,897 26,879 29,809 29,843 30,806 35,184 34,734 34,734 33,810 28,843 26,879 Ending Cash Balance 105,935 109,561 114,123 117,672 125,060 133,365 141,129 153,179 165,228 170,530 176,964 181,526 Less: Minimum Cash 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Surplus (Deficit) 90,935 94,561 99,123 102,672 110,060 118,365 126,129 138,179 150,228 155,530 161,964 166,526

Similar Documents

Premium Essay

Ecn601 Full Course Latest All Discussions and All Assignments

...ECN601 full course latest all discussions and all assignments Click Link Below To Buy: http://hwcampus.com/shop/ecn601-full-course-latest-all-discussions-and-all-assignments/ ECN601 WEEK 1 DQ 1& DQ 2 LATEST 2015 DQ 1 The price of gasoline goes up and down quickly, yet consumer demand for gasoline stays relatively steady. Does this mean the demand for gasoline is inelastic, or is something else at work? Explain. DQ 2 Of the factors listed in the textbook that are related to demand, identify 1 or 2 that were instrumental in your selection of a University in which to enroll for an MBA. Do you think your decision criteria are typical or atypical? Explain. ECN601 WEEK 2 DQ 1& DQ 2 LATEST 2015 DQ 1 Selecting a complete set of independent variables is always an issue when using regression analysis to estimate demand. For example, analysts often use price and advertising to estimate quantity demanded. However, how do they know that these two variables were sufficient? How do we know that we didn’t omit other variables which would have had a significant impact on demand? How do we know that we didn’t include variables that were not needed? Explain how analysts would answer such questions. DQ 2 Suppose you want to use regression analysis to estimate the selling price of single family homes in a given neighborhood. You assemble data on selling price, square footage, number of bedrooms, number of bathrooms, age of the house, and lot size. Which variable(s) are dependent...

Words: 2022 - Pages: 9

Premium Essay

Ecn601 Full Course Latest All Discussions and All Assignments

...ECN601 full course latest all discussions and all assignments Click Link Below To Buy: http://hwcampus.com/shop/ecn601-full-course-latest-all-discussions-and-all-assignments/ ECN601 WEEK 1 DQ 1& DQ 2 LATEST 2015 DQ 1 The price of gasoline goes up and down quickly, yet consumer demand for gasoline stays relatively steady. Does this mean the demand for gasoline is inelastic, or is something else at work? Explain. DQ 2 Of the factors listed in the textbook that are related to demand, identify 1 or 2 that were instrumental in your selection of a University in which to enroll for an MBA. Do you think your decision criteria are typical or atypical? Explain. ECN601 WEEK 2 DQ 1& DQ 2 LATEST 2015 DQ 1 Selecting a complete set of independent variables is always an issue when using regression analysis to estimate demand. For example, analysts often use price and advertising to estimate quantity demanded. However, how do they know that these two variables were sufficient? How do we know that we didn’t omit other variables which would have had a significant impact on demand? How do we know that we didn’t include variables that were not needed? Explain how analysts would answer such questions. DQ 2 Suppose you want to use regression analysis to estimate the selling price of single family homes in a given neighborhood. You assemble data on selling price, square footage, number of bedrooms, number of bathrooms, age of the house, and lot size. Which variable(s) are dependent...

Words: 2022 - Pages: 9

Premium Essay

Finance

...[pic][pic] FIN 222 Corporate Finance Individual Major Assignment [80 marks] This manual outlines the followings. Objective of the assignment Details of questions (Instructions will be provided wherever necessary.) Format requirements Printing requirements Submission requirements ➢ Objective of the Assignment In Lecture 5 (CH11 and CH12), you were introduced to the concept of systematic risk, as measured by beta. Beta is an indicator of an asset’s exposure (or vulnerability) to systematic risk and evaluates the degree to which an asset’s return is correlated with the market return. Beta is a key parameter in the Capital Asset Pricing Model (CAPM) which is most commonly used asset pricing model for the estimation of required rate of returns on a share (i.e. cost of equity=rE). This assignment consists of two parts. Part I directs you to work with real financial data in Excel and aims to take you through the basic exercise of estimating a company beta and computing statistics which can be evaluated as part of investment decision-making process. Part II requires you to write a report based on interpretations of the outputs obtained from the first part. In this manual, you will also find out how to download historical share price, market index data and interest rates from the web portal. ➢ Details of Questions PART 1 [30 marks] To successfully complete PART 1, please read each section carefully. You must read “Format and printing requirement” before you...

Words: 3262 - Pages: 14

Premium Essay

Zedbox

...FINANCE 301 Spring 2013 Instructor: Carlene B. Stabile Assignment - Capital Budgeting, Breakeven Analysis and Sensitivity Analysis The Proposal The Research and Development Division of your company has just developed a new gaming system called the Zed Box. The R&D Division spent $800,000 developing this product and the Marketing Division has spent another $210,000 to assess the market demand. They believe that the Zed Box system has superior graphics and speed, and will have great market appeal at a competitive price of $225. The Marketing Division estimates the following demand for the Zed Box: |Year |Units | |2014 |15,500 | |2015 |30,000 | |2016 |30,000 | |2017 |30,000 | |2018 |5,000 | After that time they believe there would be no more sales of the product as newer products become available. The Zed Box is expected to cost $132 each to manufacture (variable cost). In addition, fixed production costs are estimated at $1 million per year. The manufacturing equipment necessary to produce the games costs $2,800,000 million to buy and would be depreciated at a 30 percent CCA rate. The manufacturing equipment is expected to have salvage value equivalent to 15% of the initial cost. We would need to invest $350,000 in net working capital up front (primarily for inventory) and NWC will...

Words: 875 - Pages: 4

Premium Essay

Assignment Brief#

...Assignment brief – QCF BTECAssignment front sheet | Qualification | Unit number and title | BTEC Level 3 Extended Diploma in Business | Unit 42: Spreadsheet Modelling | Learner name | Assessor name | Martyna Litvinaite | Irene McCourt Francesse Mooney | Date issued | Hand in deadline | Submitted on | 15/09/14 | Task 1 15/10/14 Task 2 12/12/14 Task 3 20/03/15 Task 4 29/05/15 | 15/10/1410/12/14 | | | Assignment title | GamerWorld | In this assessment you will have opportunities to provide evidence against the following criteria. Indicate the page numbers where the evidence can be found. | Criteria reference | To achieve the criteria the evidence must show that the learner is able to: | | Task no. | | Evidence | P1 | * explain how spreadsheets can be used to solve complex problems | | 1 | | Pages1-2 | P2P3M1 | * develop a complex spreadsheet model to meet particular needs * use formulae, features and functions to process information * refine a complex spreadsheet model by changing rules and values | | 2 | | 2 Spreadsheets | P4P5P6P8M2M3 | * use appropriate tools to present data * customise the spreadsheet model to meet a given requirement * use automated features in the spreadsheet model to meet a given requirement * export the contents of the spreadsheet model to an alternative format * analyse and interpret data from a spreadsheet model * compare different automation methods...

Words: 302 - Pages: 2

Premium Essay

Business Decision Making

...Assignment front sheet Qualification Pearson BTEC Level 5 HND Diploma Business Student name Unit number and title Unit 6: Business Decision Making Assessor name James Kwok Date issued Completion date Submitted on 5th January 2015 16th February 2015 Assignment title BDM: To start-up a upstairs coffee cafe in the city(2 of 2) Learning Outcome Learning outcome Be able to produce information in appropriate formats for decision making in an organisational context Assessment Criteria 3.1 3.2 3.3 3.4 LO3 In this assessment you will have the opportunity to present evidence that shows you are able to: Produce graphs using spreadsheets and draw valid conclusions based on the information derived Create trend lines in spreadsheet graphs to assist in forecasting for specified business information Prepare a business presentation using suitable software and techniques to disseminate information effectively Produce a formal business report Use appropriate information processing tools Prepare a project plan for an activity and determine the critical path Use financial tools for decision making Task Evidence no. (Page no) 3 3 3 3 4 4 4 LO4 Be able to use softwaregenerated information to make decisions in an organisation 4.1 4.2 4.3 Learner declaration I certify that the work submitted for this assignment is my own and research sources are fully acknowledged. Student signature: Date: In addition to the above PASS criteria, this assignment...

Words: 1570 - Pages: 7

Premium Essay

Pos410Wk2

...of the Week 3 Learning Team Assignment.   NOTE: This is a large assignment.  Starting early in the week and giving your team time to post code for a review and assistance will help you prepare it accurately and completely.  I encourage everyone to work on the assignment throughout the week and not wait until the day it is due to begin the work.  Please see the Instructor Policies for Team Participation credit guidelines.   REQUIRED: Coding Standards for this course are required.  Please see the attached Coding Standards.   CRITICAL Resource:  The attached Errors Table is a resource for dealing with error messages and other potential obstacles you may encounter writing code.    Optional: Read the Week 2 and 3 Handouts in the Recommended Learning Activities to assist with creating this assignment.   Optional: Complete the Week 2 and 3 Learning Activity Tutorials in the Recommended Learning Activities.   REQUIRED:  Use the Kudler Chart of Accounts PROVIDED.  Analyze the "PROVIDED" Chart of Accounts spreadsheet in order to decide how you will design the database.   Plan your Data Dictionary (You will be submitting data dictionary with your final project submission, Week 5.)   REQUIRED:  Use the Data Dictionary Template attached to create the Data Dictionary for the Learning Team Assignment.   REQUIRED: Follow the instructions in the provided Excel Spreadsheet (Data Sheet) for the Kudler Chart of Accounts for creating the Excel Spreadsheet due this week.   * Rename...

Words: 1276 - Pages: 6

Premium Essay

Intellipath

...Part 1 Name: __Renee Swartz ‘’ This is my correct name’’__________________________________________________________ Computer Make and Model: __________________________________________ Operating System: __________________________________________________ Printer Make and Model: ____________________________________________ Hard Disk Size: _____________________________________________________ Amount of Random Access Memory: ___________________________________ Part 2 Paragraph 1: Follow the directions that have been supplied in the Unit 1 Individual Project to modify this document by following each step in the directions carefully. Once you have completed all of the assigned modifications to this document, you will save the document to your hard drive and then submit it using the Submissions area on the AI: U Virtual Campus under the Unit 1 INDIVIDUAL PROJECT assignment. Paragraph 2: This document is created just so that you can make modifications to it. It has spelling and grammatical errors in it. By correcting these errors and manipulating the sentences and paragraphs following the directions for the Unit 1 INDIVIDUAL PROJECT assignment, you will learn how to do many of the most common types of operations in the Word program. Paragraph 3: Word, which is a word processing computer program and much more, are an extremely powerful and full-featured business and personal tool for creating documents of all kinds, and Word is studied in Unit’s 1 and 2 in this course. PowerPoint...

Words: 833 - Pages: 4

Premium Essay

Fund Tracking

...FUND TRACKING ASSIGNMENT • For this assignment you MUST WORK IN PAIRS. • Pick your partner for this assignment BEFORE the start of WEEK 3 • In the Assignment module in SLATE Content is a link to the google drive spreadsheet where you and your partner must sign up for this assignment. Be sure to register in the correct class. • In the meantime, visit www.globefund.com and familiarize yourself with the content on the website and different ways to select mutual funds. SUBMISSION #1: 1. Due week 4 in SLATE Dropbox (see Dropbox for exact date and time). 2. One partner will invest $10,000 in each of 3 actively managed* mutual funds managed by Canadian mutual fund companies. See Appendix for a list of potential mutual fund companies and funds to choose from. One fund must be chosen from each of the following categories: • Canadian Equity • Emerging Markets Equity • Canadian Fixed Income *Remember, actively managed means it does NOT follow the related index but tries to outperform the index by selecting only what the portfolio managers believes will be the best performing securities. 3. One partner will invest $10,000 in each of 3 passively managed Exchange Traded Funds with one ETF coming from each of the following categories. Canadian Equity STOCK SYMBOL Globefund Code BMO S&P/TSX Capped Composite Index ETF ZCN BMOCANEQ iShares Core S&P/TSX Capped Composite Index ETF XIC IUNSTCID Vanguard Canada - FTSE Canada Index ETF VCE VANMSCCA Emerging...

Words: 1350 - Pages: 6

Premium Essay

Syllabus

...Required Textbook: 1. Financial Modeling by Simon Benninga, MIT Press, Third edition. Other Recommended Books: 1. Corporate Finance, Stephen A. Ross, Randolph W. Westerfield, and Jeffrey Jaffe (RWJ), Irwin/McGraw-Hill. (you should have this from the core class). 2. Damodaran on Valuation, Wiley. 3. Spreadsheet Modeling in Corporate Finance by Craig Holden, Prentice Hall. 4. Analysis for Financial Management, Robert C. Higgings, Irwin/McGraw-Hill. 5. MBA’s Guide to Microsoft Excel 2000, Stephen L. Nelson, Redmond Technology Press. Course Packet: The course packet contains the cases that will be assigned during the semester. Assignments and lecture notes will be distributed in class. Exams: There will be one take-home final exam. The final exam will be based on spreadsheets built using techniques for financial modeling developed throughout the course. The exam will require individual ability to perform advanced financial modeling using a spreadsheet. Class Participation: A vibrant class discussion will raise the level of enjoyment and learning for all of us. Therefore, it will help if you take the time to prepare and do the readings before the class. You should read the assigned chapters before coming to the lectures. In addition to discussing the material, you should also be familiar with the modeling techniques and spreadsheet tools used in each class. Grading Policy: 1. Late assignments are never accepted for credit unless there are extenuating circumstances...

Words: 460 - Pages: 2

Free Essay

Finance

...Deliverables Company Selection – Week 1 Course Project Horizontal Analysis – Week 2 Course Project Vertical Analysis – Week 3 Course Project Final Ratio Analysis – Week 4 General Expectations for Your Final Course Project Submission – Week 7 Citation Help |Deliverables | | Course Project Company Selection Please post your chosen companies for comparison for my approval in the Week 1 Course Project Dropbox by Sunday, end of Week 1, 11:59 p.m. (MT). I will give you feedback to make sure that you're on the right track for this assignment. (5 points) Course Project Horizontal Analysis Please post the horizontal analysis for your Course Project in the Week 2 Course Project Dropbox by Sunday, end of Week 2, 11:59 p.m. (MT). (40 points) Course Project Vertical Analysis Please post the vertical Analysis for your Course Project in the Week 3 Course Project Dropbox by Sunday, end of Week 3, 11:59 p.m. (MT). (40 points) Course Project Final Ratio Analysis Please post the Ratio Analysis for your Course Project in the Week 4 Course Project Dropbox by Sunday, end of Week 4, 11:59 p.m. (MT). (40 points) Final Course Project Submission Please post the Course Project final summary assignment to the Week 7 Course Project Dropbox by Sunday, end of Week 7, 11:59 p.m. (MT). (75 points) |Category ...

Words: 1561 - Pages: 7

Free Essay

Bae Project

...Homework #2 – Excel Charts and Pivot Tables Overview and Learning Objectives This homework assignment asks you to use Microsoft Excel to use the VLookup function in a report, and also to generate charts and pivot tables. These are all useful skills. VLookup simplifies spreadsheet logic in many situations, and charts offer a visual perspective that can help people to see trends and data relationships. And once you get the idea of pivot tables, they are extremely useful in summarizing data “on the fly” in a variety of formats. This assignment is related to course objective #4 (“Design and implement Microsoft Excel spreadsheets and Microsoft Access databases to support business decision making”). Quality Furniture Enterprises, Continued This homework assignment continues the scenario from Homework #1, about Quality Furniture Enterprises. Caitlin’s uncle (and boss) was pleased with the sales forecast report she created. “I guess I should learn Excel,” he says. “I’ve been using the calculator on my laptop to compute the totals, and then copying and pasting things into a Word document.” Caitlin did her best not to appear smug, but it was nice to be appreciated, especially since this was still her first month on the job. But before she had any time to bask in her success, her uncle said, “And since you did so well on that report, I have another project for you.” So much for taking an early lunch break today. “Sure,” she said. “What do you need?” “First off, remember how I told...

Words: 1904 - Pages: 8

Premium Essay

Danish Kabiri

...Online Assignment Six Due: 5:30 pm on 04/28 Instruction: An Excel file including two spreadsheets is created for you to work on the assignment problems. Those two spreadsheets are named as Problem 1 and Problem2. You can use this template to complete online assignment six and use the submission link to submit the assignment by the due date. I also created a “node” and an “arc” in problem 1 spreadsheet. You can copy it to create all nodes and connections. The Excel assignment file should include your name. (e.g. John Smith HW 5) #1 Monohan Machinery specializes in developing weed-harvesting equipment that is used to clear small lakes of weeds. George Monohan, president of Monohan Machinery, is convinced that harvesting weeds is far better than using chemicals to kill weeds. Chemicals cause pollution, and the weeds seem to grow faster after chemicals have been used. George is contemplating the construction of a machine that would harvest weeds on narrow rivers and waterways. The activities that are necessary to build one of these experimental weed-harvesting machines are listed in the following table. Construct a network for these activities. ACTIVITIES IMMEDIATE PREDECESSORS A B C A D A E B F B G C, E H D, F #2 After consulting with Butch Radner, George Monohan was able to determine the activity times for constructing the weed-harvesting machine to be used on narrow rivers. George would like to determine ES, EF, LS, LF, and slack for each activity. The total project completion...

Words: 299 - Pages: 2

Premium Essay

Apdms

... |[pic] | ASSIGNMENT FRONT SHEET |Student Name: | |Certification : I certify that the whole of this work is the result of my individual effort and that all quotations from books, periodicals etc. | |have been acknowledged. | |Student Signature: |Date: | |Student Registration Number: | |Student email address : | |Programme : Business |Year/Level : 1 | |Academic Year : 2012/13 |Semester : 2 | |Module title : Academic & Personal Development |Assignment no. : 2 (IT) | |Module code: BUS 406 ...

Words: 1335 - Pages: 6

Premium Essay

Destin Brass Products Co. Case Analysis Required Questions Solution

...Products Co. by William J. Bruns Jr. It should cost you $3.95. There is also a supplemental spreadsheet that you should download to work from. Disregard the questions at the end of the case. You should answer the following questions: Requirement #1 – Using Activity Based Costing to determine the cost per product. a.) Use Exhibit #4 to calculate the activity rates per each activity for the material related overhead and the other overhead amounts. b.) Use the rates you calculated in part a to calculate the total overhead applied to each product. (You should use the activities in Exhibit 5. Where activity numbers have been provided use the actual activity amounts not their percentages as the case writers have rounded their percentages. For example use the number of transactions 4 + 25 + 100 = 129 transactions not 3% + 19% + 78%) c.) Don’t forget to use the Material, Set up labor, and Direct labor, costs provided for each product in Exhibit 4. Requirement #2 – Compare the cost you got for Requirement #1 to the standard cost in Exhibit #3 and the Revised Unit Cost in Exhibit #4. What is causing the different costs per product between the three different costing methods? a.) Put all three costs on one spreadsheet so you can see the differences. Requirement #3 – Compute the Profit Margin for each product using all three costing methods. Use the actual price from Exhibit #1. Based on your analysis, what actions would you suggest the managers at Destin do? a.) Consider...

Words: 740 - Pages: 3