MBA 504

MAC 502

Spreadsheet Modeling

Assignment #8

Prof. Liz Durango-Cohen

The data needed for this problem set is contained in worksheet “MBA_504_MAC_502_Problem_Set_#8_F14.xls”

Problem 1: Writer’s Edge is a seller of fine fountain pens. The company has found that, in spite of the growth in online buying, its catalog business is still quite strong. With the holiday season coming Writer’s Edge is planning to run a new direct mail campaign. Relevant information includes:

The cost of printing the holiday season catalog is $30,000 in fixed costs plus $0.23 per catalog.

The cost of mailing each catalog (postage + cost of purchasing names and addresses of potential customers from a list vendor) is $0.39.

Each catalog will*…show more content…*

In addition, you may be transferred to another post in three to six months, so you may have to pass on the responsibility to a successor before too long.

It is 6:00 a.m. Monday morning. You have three hours left at the city headquarters until you leave to begin two weeks of fieldwork in the villages without computer access. The initial order must be placed by next Friday, so you will have to take care of procuring a check from the finance officer and placing the order before you leave.

Other team members are beginning to arrive, but the office is still quiet. Everything else on your plate can wait until you return. Yet, something else could pop up at any moment, so you have to work quickly. You don 't have the latest population or stock figures yet, but the team member who has them will arrive at 8:30 a.m.

Design a spreadsheet that will enable you to request the required funds from your team’s finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village. Your final order to the home office should specify the number of packages required of each item.

a. The population figures show that there are 3,000 children, 2,500 teenagers, 500 seniors, and 9000 other adults in the population. In there are no stocks on hand, what amount would be required for ordering supplies? b. Using the parameters in (a), construct a graph showing how the amount required for the order would vary if the unit cost of

MAC 502

Spreadsheet Modeling

Assignment #8

Prof. Liz Durango-Cohen

The data needed for this problem set is contained in worksheet “MBA_504_MAC_502_Problem_Set_#8_F14.xls”

Problem 1: Writer’s Edge is a seller of fine fountain pens. The company has found that, in spite of the growth in online buying, its catalog business is still quite strong. With the holiday season coming Writer’s Edge is planning to run a new direct mail campaign. Relevant information includes:

The cost of printing the holiday season catalog is $30,000 in fixed costs plus $0.23 per catalog.

The cost of mailing each catalog (postage + cost of purchasing names and addresses of potential customers from a list vendor) is $0.39.

Each catalog will

In addition, you may be transferred to another post in three to six months, so you may have to pass on the responsibility to a successor before too long.

It is 6:00 a.m. Monday morning. You have three hours left at the city headquarters until you leave to begin two weeks of fieldwork in the villages without computer access. The initial order must be placed by next Friday, so you will have to take care of procuring a check from the finance officer and placing the order before you leave.

Other team members are beginning to arrive, but the office is still quiet. Everything else on your plate can wait until you return. Yet, something else could pop up at any moment, so you have to work quickly. You don 't have the latest population or stock figures yet, but the team member who has them will arrive at 8:30 a.m.

Design a spreadsheet that will enable you to request the required funds from your team’s finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village. Your final order to the home office should specify the number of packages required of each item.

a. The population figures show that there are 3,000 children, 2,500 teenagers, 500 seniors, and 9000 other adults in the population. In there are no stocks on hand, what amount would be required for ordering supplies? b. Using the parameters in (a), construct a graph showing how the amount required for the order would vary if the unit cost of

Related

- Better Essays
## Managerial Economics Case Problem Solution Essay

- 1168 Words
- 5 Pages

1) Problem 6: Suppose demand and supply are given by Qd = 60 – P and Qs = P – 20.

- 1168 Words
- 5 Pages

Better Essays - Good Essays
## Hamptonshire Express Essay

- 2159 Words
- 9 Pages

Problem #3 A. Assuming the number of hours Anna Sheen will spend developing the profile section will = 4; Ralph Armentrout’s optimal stocking quantity is 516, as portrayed in the table below:

- 2159 Words
- 9 Pages

Good Essays - Decent Essays
## Lancer Gallery Case Analysis

- 639 Words
- 3 Pages

Lancer group is approached by a Mass merchandise to sell its products with an assortment of Lancer products. The initial purchase order would be of 0.75 million and the estimated order per annum would be 4 million .The other clauses in the deal are as mentioned

- 639 Words
- 3 Pages

Decent Essays - Decent Essays
## Operations Managements

- 2518 Words
- 11 Pages

------------------------------------------------- Answer | | 7200 | | | 4000 | | | 2400 | | | 1200 | | | 600 | 5 points Question 9 1. ------------------------------------------------- ------------------------------------------------- A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 60 units per day. The setup cost for a production run is $ 125.00. The cost of holding is $ 4.00 per unit per year. The demand for the item is continuous and constant and is 3,900 units per year. (Note: The demand occurs only when the company is operating, that is, 5 days a week for 52 weeks). Find the optimum number of units to be produced in one batch (economic production quantity). Round the number to nearest integer.

- 2518 Words
- 11 Pages

Decent Essays - Decent Essays
## Essay on Fedex Courier Case

- 1117 Words
- 5 Pages

The 5 minimum purchase costs $62.50, which creates a barrier for those who are willing and able to send something within a tight time constraint. Envelopes should be provided for free, and charged upon the actual service of mailing out the package. Corporations enjoy flexibility. We believe that CPs should be marketed as a product that is great for reliability and speed, making a point that they

- 1117 Words
- 5 Pages

Decent Essays - Decent Essays
## Dirt Bike # 10

- 866 Words
- 4 Pages

SHIPPING RATES WITHIN THE CONTINENTAL U.S. & TO APO/FPO ADDRESSES GROUND SHIPPING RATES Invoice Total Rate 0-$49.99 $6.99 $50-$99.99 $7.99 $100-$149.99 $12.99 $150-$199.99 $16.99 $200-$299.99 $18.99 Over $299.99 FREE Bike Lifts $25.00 Extra Wide Bike Ramp $50.00 Complete Motors $100.00 Rolling Chassis Kits $175.00 Trailers $300.00 C.O.D. Add $7.00 For this company however, if the package is 5 lbs and The Execution section handles the actual flow of material, products, and services. Included in that is the informational and financial flow of things in and out of the company. The Performance section focuses on all the decision-making process along all of the supply Chains. This software also offers a lot of training for using the software; there is IFS eLearning, Web-Based Training, Classroom Training, Informational Webcasts and Customized Training, all made to help the user work well with the software. This software package is built for a medium to large organization (101- 2000+).

- 866 Words
- 4 Pages

Decent Essays - Decent Essays
## Brs Mdm3 Tif Ch04

- 4341 Words
- 18 Pages

Formulation Max 10A + 10B + 10C Subject to: 3A + B + 5C ≤ 300 (constraint #1) 2A + 4B ≤ 400 (constraint #2) 4A + 2B + 3.5C ≤ 200 (constraint #3) C ≥ 10 (constraint #4) A, B, C ≥ 0 9) Which constraints are binding? A) 1 and 2 B) 1 and 4 C) 2 and 3 D) 3 and 4 E) 2 and 4 Answer: D Page Ref: 130 Topic: Sensitivity Analysis Using Graphs Difficulty: Easy 10) What is the optimal objective function value? A) 925 B) 825 C) 100 D) 92.5 E) none of the above Answer: A Page Ref: 130 Topic: Sensitivity Analysis Using Graphs Difficulty: Easy 11) By how much would the profit contribution of product A has to increase before it will be profitable to produce A?

- 4341 Words
- 18 Pages

Decent Essays - Decent Essays
## Specialty Toys Essay

- 607 Words
- 3 Pages

The product management team asks you for an analysis of the stock-out probabilities for various order quantities, an estimate of the profit potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty’s senior sales forecaster predicted an expected demand of 20,000 units with a .95 probability that demand would be between 10,000 and 30,000 units.

- 607 Words
- 3 Pages

Decent Essays - Better Essays
## Essay about Caso Hamptonshire Express

- 2228 Words
- 9 Pages

9-698-053 REV: AUGUST 30, 2002 V.G. NARAYANAN ANANTH RAMAN Hamptonshire Express Problem #1 Anna Sheen, upon graduating from a Boston-area university with a degree in journalism and operations research, returned to her hometown of Hamptonshire, Pennsylvania, to start a daily newspaper. The Hamptonshire Express emphasized local news which Sheen believed was not adequately covered by big-city newspapers such as

- 2228 Words
- 9 Pages

Better Essays - Decent Essays
## Supply and Demand and Optimal Selling

- 1173 Words
- 5 Pages

Page 1 of 4 Math 116 Review 1 1. Suppose that the total cost of manufacturing q units of a certain product is C q thousand dollars, where C q q3 30q2 500q 200 a) Find the total cost and the average cost of producing 10

- 1173 Words
- 5 Pages

Decent Essays - Decent Essays
## Essay on Operating Management

- 2081 Words
- 9 Pages

a. lead time b. replenishment quantity *c. reorder point d. service level 4. A restaurant currently uses 62,500 boxes of napkins each year at a constant daily rate. If the cost to order napkins is $200.00 per order and the annual carrying cost for one box of napkins is $1.00, then the optimal order quantity (EOQ) for napkins would be

- 2081 Words
- 9 Pages

Decent Essays - Decent Essays
## Sample Resume : Mr. M. T. H. J. D. C. R.

- 1122 Words
- 5 Pages

Introduction Mr. Busfield accepting the possession at his direct cost would entail his effort to find the Economic Order Quantity for measuring cups. This is accomplished by combining the inventory carrying and ordering cost. In the event of calculating the EOQ through ordering and maintaining inventory product quantities have to be at a stable demand and cost level throughout the year. (Bowersox, D. J., Closs, D. J., Cooper, M. B., & Bowersox, J. C. p. 156. 2013) Mr. Busfield’s company would have to calculate this level accurately from the information that he gathers from the cost of orders products, annual inventory carrying cost, annual sales volume, units; and cost per unit. There the calculations would be calculated from figures from the previous question of finding the reorder point for spatulas. (R=DXT+SS) calculated from = 400 x 14 + 500 = 6,100 (Bowersox, D. J., Closs, D. J., Cooper, M. B., & Bowersox, J. C. p. 157. 2013). To find the economic order quantity (EOQ) would be the square root of the product of the numerator two times order cost and demand divided by the product of the annual total cost. “Inventory Carrying Costs = (2,797/2) x 0 .75 x 12% = $ 125.87. (44,000/2797) = Order costs= 16 orders x $8 / order = $ 128.00. Transportation Costs = 44,000 units x $0 .05 / unit = $ 2,200. Total Cost (EOQ = 2,797 units) $ 2,453.87 /year. Annual total cost with order quantities of 4,000 cups (Ultimate Calculators 2010).”

- 1122 Words
- 5 Pages

Decent Essays - Decent Essays
## Essay about Assignment

- 1252 Words
- 6 Pages

Seoul National University Supply Chain Management May 11 – May 22, 2015 Homework Assignment Completed assignment is due at the start of Session 7 on Tuesday, May 19. This assignment is to be completed in a group of 2 or 3 students. Submit a hard copy, not an electronic copy (typed answers are preferred). Show your

- 1252 Words
- 6 Pages

Decent Essays - Satisfactory Essays
## Operation Management Midterm Sampple

- 1034 Words
- 5 Pages

|Midterm Example Test v2 | | 1. A manufacturing firm is considering three alternatives for automation. They anticipate annual production volume to be 75,000 units. The costs for each

- 1034 Words
- 5 Pages

Satisfactory Essays - Better Essays
## Effects Of Westernization On Arabs ( Working Women ) Essay

- 1688 Words
- 7 Pages

EFFECT OF WESTERNIZATION ON ARABS (WORKING WOMEN): INTRODUCTION: The United Arab Emirates (UAE) is an example of a rapid and successful development story in the Region, in terms of both the infrastructure and economy of the country and also the progress of its People. The UAE’s achievement is perhaps best typified in the evolution

- 1688 Words
- 7 Pages

Better Essays