Preview

Supply Chain Task 1

Better Essays
Open Document
Open Document
2621 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Supply Chain Task 1
Supply Chain-Operations Management JCT2 TASK 1
MBA 9/1/2014

Part A
Cumulative Balanced Scorecard ending with Quarter 4

Income Statement showing Quarters 1-4

Balance Sheet showing Quarters 1-4

Part B

B1: Evaluate how you utilized budgets and pro-format statements to plan funding of the production capacity you needed to achieve your business goals.
At the end of the first quarter I had a net income of $-338,500.00, which was not a huge surprise given that I had not yet sold anything and was trying to get the business off the ground. I knew however, that in order for the business to be successful, I would need to be somewhat conservative in Quarter 2. I chose to target the Mercedes and Travelers market segments as these two had several top things they wanted in a computer in common. While the market sizes were smaller, I thought if I produced the right products, I could be a market leader for both target segments.
In Quarter 2 I projected a demand of 350 units for my primary target market, the Mercedes group, and 170 units for my secondary group, the Traveler. My total forecasted demand was 500 units, and my available operating capacity was 520 units. I decided to sale my product to the Mercedes group for $3800.00/unit with a $100 rebate/unit and sold my product to the travelers for $3000.00/unit with a $100/rebate. I operated at 100% capacity for Quarter 2. I sold out of both products, under estimating my consumers. For the Mercedes group, I lost out on 158 sales and for the Travelers I lost out on 74 sales. At the end of quarter 2, I was still operating at a loss, but had significantly cut my loss from $-338,500 to $-195,018. Thanks to the common stock I sold this quarter, I still had a cash balance over a million dollars which helped me make changes for quarter 3.
In Quarter 3 I increased my projected demand to a total of 2,000 units. I projected 1,250 units for the Mercedes group and 750



References: Ahmed, S. (2014, March 25). Just in Time (JIT) Manufacturing and Inventory Control System. Retrieved from Management Accounting: http://accounting4management.com/just_in_time.htm Heizer, J., & Render, B. (2010). Operations Management 10th Edition. Prentice Hall.

You May Also Find These Documents Helpful

  • Powerful Essays

    Final Accounting

    • 1555 Words
    • 5 Pages

    As reflected in the Production Budget captured in Exhibit B below and included in the overall Peyton Approved budget worksheet included in Appendix A. First budgeted sales units for each month in the quarter was used to multiply with ratio to inventory future sales to compute budgeted ending inventory. The company stated that it was company's policy to have a given month's ending finished goods inventory to equal 70% of the next month's expected unit sales. Then, budgeted sales units of 18,000, 22,000 and 20,000 units are added to the budgeted ending inventory units of 15,400, 14,000 and 16,800 units for the month of July, August and September, respectively to arrive to required units to be produced of 33,400, 36,000 and 36,800 units for each respective months. Subsequently, beginning inventory is deducted from required…

    • 1555 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Fina310 Unit 2

    • 410 Words
    • 2 Pages

    The second part of the Individual Project is to consider the Micro Chip’s Consolidated Statement of Operations for the year ended September 25, 2008. With this information the percentage sales method and a 25% increase in sales is to be used to forecast Micro Chip’s Consolidated Statement of Operations for the period of September 26, 2008 through September 25, 2009. For this we are to assume a 15% tax rate and a restructuring cost of 5% of the new sales figure. After doing all of the calculations I have the results for the forecast of the Micro Chip’s company. The assumption I have made is that everything is going to go up and the net income is going to be higher than the year before. By looking at the information I do not think that any of my assumptions are unreasonable.…

    • 410 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Supply Chain Task 1

    • 1619 Words
    • 7 Pages

    To evaluate how I utilized both budgets and pro-formas to ensure the adequacy of funds for providing production capacity that was needed to achieve the businesses goals. I want to first start with the definition of both pro-forma and budget; A budget is a basic idea that covers more than a few areas, all in all it's a financial plan that is made to control costs for operations and results. It can be expressed in a multitude of numerical terms, it also can cover a certain period of time, short, intermediate and long term goals. A pro-forma is also a financial statement but it is prepared based upon assumptions of specific events and transactions that will hopefully occur in the Future, so basically a projected estimate using historical data to form a hypothesis of A financial outcome. The importance of both the pro-forma and budget were huge. Knowing going into the simulation how much seed money was going to be issued and how much additional money was coming in future investments, gave me an idea of how aggressive or conservative I could be. I was able to to set with an initial idea of how much I could spend for each factor needed moving forward. I was able to understand how much to market, how much to hire and how much I could afford for each of these tasks, as well as how much was coming into pay for future marketing and hires. Without advertising there are no customers, without a good sales and service staff there are no sales, or an ability to take care of the customer. In the opening quarter of the company I had a 2 million dollar start-up fund. My upfront expenses were approximately $530,000. I also chose to invest in a 3 month CD about $880,000, I made sure in my first endeavor to keep money available and not to over indulge. I took similar approaches going…

    • 1619 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Supply Chain Task 2

    • 1199 Words
    • 5 Pages

    1. As I began my journey as a new business owner of a computer company I needed to define my company 's goals, decide which direction I wanted to take the company to and create a mission statement that will best represent my company. Since the company was new I needed to come up with something catchy and promising that would invite potential clients to find out more about the products we offer. Since there were more participants in this game and from my professional experience I learned that staying on the same path and making advancements is more beneficial than trying to change directions every time. In this case I remained focused on the same two groups for the remaining 3 rounds. Instead of changing and adding more products every quarters like most of the other participants I kept my two models (one for each group) and made necessary corrections and modifications based on the market needs. I verified the requirements of each group, the priorities and the price range each client is willing to pay. Since there are no specific techniques used in this part of the business analysis I used my own judgment in making sure that I create the best product with the items that are most important to the potential client group. As stated above I initially created two products (one for each group) and after the first round they both passed 70% but in the scientific group it was not chosen as one of the best. In the second round I was given an option of reviewing products of my competitors and the only difference was the larger monitor and an upgraded keyboard. I added those options to my products and in the next round both products did very well. I had to make sure that in the nest round I keep up with the new upgrades and add them to my products to make sure that I keep up with the new technology. Even after making the upgrades the prices did not change a lot and the two groups still chose my product as one of…

    • 1199 Words
    • 5 Pages
    Good Essays
  • Good Essays

    I was given two full years of sales data, and took a look at the net revenue of each of your sales representatives. At first glance it looks like 2005 might have been a more profitable year, but bear in mind that 2005 is the only year we all four quarters accounted for. Keeping…

    • 741 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Hallstead Jewelers

    • 987 Words
    • 4 Pages

    1.) Break-even ticket sales increased from 4533 in 2003, to 4998 in 2004 and 7491 in 2006. Break-even point in Sales Dollars has changed from $7,285 in 2003, to $7,617 in 2004 and $11,634 in 2006. (Table 1) The margin of safety has changed from $1,298 in 2003, to $485 in 2004, and a loss of $923 in 2006. (Table 2) There is a decrease from 2003 to 2006. Fixed cost per month attributed to stores relocation and subsequent renovations caused a decrease from 2003 to 2006. Other factors contributing to the 2003-2006 decrease are as follows: • 1% increase in Cost of Goods Sold (COGS) totaling $81,000 • Decrease in sales of $481,000 • Increase in salaries totaling $60,000 • Increase in miscellaneous expenses of $40,000. (Table 3) 2.) If prices were reduced by 10 percent, Hallstead’s total income would decrease to $1,111. This would change the break-even point for ticket sales to 9,637, and significantly change the overall sales figure to $13,473 (Table 4). 3.) Gretchen’s idea would effectively eliminate sales commissions. This would reduce sales volume by 1,143. This would decrease ticket sales to 8,494 and compromise the break-even. Sales dollars would reduce by $1,598 to $11,875 (Table 4). 4.) Michaela’s suggestion to increase advertising by $200,000 is sound: The increase accounts for 2% of sales and 4% of 2006 sales. Both figures are comparatively low for a retail business. This increase would change the break-even point from 7,491 to 7,790 ticket sales (Table 5). 5.) If fixed costs remained static from 2006 to 2007, average sales ticket would have to increase from $1,553 to $1,690 in order to break-even. (Table 6). List of recommendations for Hallstead Jewelers are as follows: Evaluate the number of sales staff needed and consider reducing the number of FTE’s and/or PTE’s. When reducing staff and/or operating, make sure that the best sales associates are receiving the number of hours they desire and then allocating the remaining…

    • 987 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Supply Chain Task 2

    • 1092 Words
    • 5 Pages

    I made my brand design decisions in the simulation by taking into account what the customers were looking for in a product. The simulation provided me with information as to what was important to the customer and what the customer wanted in their ideal computer. I then took that information and made sure that I included all of it in the product. In the first design which was aimed at the Mercedes target market; I did not make the screen size as big as the customer wanted it. When the simulation showed me my product compared to my competitor’s product, my competitors were in the lead. After seeing this information I changed the design to the screen size and made it bigger. I also included some extra games and made the keyboard more user friendly. My results after the changes were favorable. After making a few changes to the advertising as well, we emphasized on those factors that were important to the customer including the screen size. We then started to do better than our competitors. The simulation showed that we were the preferred brand within customers of the Mercedes and the Travelers market. For the Workhorse market I determined the design decisions just as I did the Mercedes and Travelers market. I made sure to include everything the customer was looking for according to the information the simulation provided me. Our product aimed at the Workhorse market did well and was the preferred brand from the time it was introduced.…

    • 1092 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Manzana

    • 1120 Words
    • 5 Pages

    2. Profits started declining from Q4 ­ 1989 and now the branch is under losses from the last two…

    • 1120 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Business Memo-Accounting

    • 459 Words
    • 2 Pages

    I created three scenarios to the original data case. In scenario 1, I make sales volume increased by 10%, compared with making sales volume fell by 10%, and it turns out that 10% increase in sales units also increase the production cost, direct-labor cost and manufacturing over-head. As well, 10% decrease in sales will cause decreases in the company’s cost. In scenario2, the company changes the policy of the end-of-month inventory. It is obvious that it almost make no changes in all of the three kinds of costs. So a new inventory policy can be carried out to not increasing the costs and at the same time meet the market needs. In scenario3, I assume that employee medical insurance increases 5 times and not install the new equipment. From the budget schedules, it shows us that the direct-labor cost increases fiercely, but the manufacturing cost remains the same level. It indicated that new equipment helps a lot decrease…

    • 459 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    SCM sem 1 txtbk

    • 272 Words
    • 3 Pages

    International Marketing - An SME Perspective by Sean De Burca, Linden Brown and Richard Fletcher, Published by Person Education…

    • 272 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Markstrat Final Report

    • 2968 Words
    • 9 Pages

    Firm E performed very well during the 8 periods we were in control. During those periods we grew the company’s contribution margin from $14.2 million dollars up to $70 million dollars and oversaw a stock price increase of over 170%. During this period we managed a maximum of 5 brands. Three of these five brands are making substantial profits totaling $75.7 million in the 8th period. The other two brands were targeted at the emerging Vodite market and although they are not currently seeing a profit, projections show they are on track to see profits within the next 2 periods (Exhibit #: chart showing Vodite sales)…

    • 2968 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Balanced Scorecard

    • 437 Words
    • 2 Pages

    Profits were higher than anticipated but the Return on Capital Employed was well below expected amount. This may well cause Shelly to reconsider her investment in the business. She may desire to search for a partner to buy into the business or an investor to supplement the initial investment. Alternatively, she may reduce the quarterly profits while increasing her the return of her capital employed.…

    • 437 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Student

    • 4198 Words
    • 17 Pages

    Our group agreed that our low amount of sales was a weakness. We made the least amount of profit out of any other firm, even though we had about the same amount of expenses as most other firms. The reason we didn’t make as much money was because we sold less products than any other firm. We made our first goal of the market action plan be to raise sales form…

    • 4198 Words
    • 17 Pages
    Good Essays
  • Satisfactory Essays

    Chap001 Oscm

    • 580 Words
    • 3 Pages

    • Concerned with the management of the entire system that produces a good or delivers a service…

    • 580 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    final exam-supply chain

    • 2433 Words
    • 9 Pages

    1. How does a raw material’s status as pure, weight-losing, or weight-gaining influence the facility location decision? P178…

    • 2433 Words
    • 9 Pages
    Good Essays