Purchase Solution

Syrup production and inventory schedule Backwoods General Store.

Not what you're looking for?

Ask Custom Question

The Backwoods General Store in Vermont sells a variety of outdoor clothing items and equipment, and several food products at its modern but rustic-looking retail store. Its food products include salmon and maple syrup. The store also runs a lucrative catalog operation. One of its most popular products is maple syrup, which is sold in metal half-gallon cans with a picture of the store on the front.

Maple syrup was one of the first products the store produced and sold, and it continues to do so. Setting up the syrup-making equipment to produce a batch of syrup costs $450. Storing the syrup for sales throughout the year is a tricky process because the syrup must be kept in a temperature-controlled facility. The annual cost of carrying a gallon of the syrup is $15. Based on past sales data, the store has forecasted a demand of 7,500 gallons of maple syrup for the coming year. The store can produce approximately 100 gallons of syrup per day during the maple syrup season, which runs from February through May.

Because of the short season when the store can actually get sap out of trees, it obviously must produce enough during this 4-month season to meet demand for the whole year. Specifically, store management would like a production and inventory schedule that minimizes costs and indicates when during the year they need to start operating the syrup-making facility full time on a daily basis to meet demand for the remaining 8 months.

Develop a syrup production and inventory schedule for The Backwoods General Store.

Purchase this Solution
Solution Summary

Syrup production and inventory schedule for The Backwoods General Store is determined.

Solution Preview

Please refer to the attached file for the response.

PRODUCTION AND INVENTORY LEVELS

GIVEN DATA:
Annual Demand (D) = 7,500 gallons
Set up cost (Cs) = $450
Carrying Cost per unit (Ch) = $15/gallon
Daily production rate (p) = 100 gallons
Daily demand rate (d) =7,500/365 = 20.54 or 21 gallons

This is a problem on optimal production quantity which is the production level that will minimize setup costs and cost of carrying the inventory.
FORMULA TO BE USED:
Q* = √(2DC s /C h(1-d/p) )
Where
Q* = optimal production quantity
D = annual demand = 7,500 ...

Solution provided by:
Elisa Valdez, PhD
Education
  • Bachelor of Science in Business Administration, University of the Philippines
  • Master in Business Administration, Saint Mary's University
  • Doctor of Philosophy in Education, University of the Philippines
  • Doctor in Business Adminstration (IP), Polytechnic University of the Philippines
Recent Feedback
  • "Excellent information thanks for the input"
  • "Thank you"
  • "Very thorough and informative. Thank you."
  • "Good response. Very detailed"
  • "This solution is excellent. Thank you"
Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Physical Flow Schedule and Computing Cost

    316547 Physical Flow Schedule and Computing Cost 1. Medi Syrup is a large cough syrup producer. The cough syrup passes through several stages during production. In department B, the following activity was recorded for October.

  • Cost Reconciliation Schedule: Maple Inc.

    535949 Cost Reconciliation Schedule: Maple Inc. Maple, Inc. manufactures syrup that goes through three processing stages prior to completion.

  • Hawaii Sugar Company Linear Programming Problem

    The company purchases 4000 tons of syrup weekly and is contracted to deliver at least 25 tons weekly of each type of sugar. The production process starts by manufacturing brown sugar and molasses from the syrup.

  • Costing and Pricing of Products

    It has variable costs totaling $2,800 and fixed costs of $1,000 per unit, based on an average production run of 5,000 units. It normally has four production runs a year, with $400,000 setup costs each time.

  • Cost accounting

    $4,000 Purchase discounts 6,000 10,000 Cost of goods purchased $152,000 Marvin Department Store Schedule of Cost of Goods Sold For the Year Ended December 31, 2008 (in thousands) Beginning merchandise inventory 1/1/2008

  • Quantitive Method

    inventory + demand = production d. beginning inventory - production - ending inventory = demand e. beginning inventory + demand + production = ending inventory 27.

  • This post calculates the increase in chocolate syrup sales.

    489140 Calculating the Increase in Chocolate Syrup Sales A grocery store notices that the cross-price elasticity between ice cream and chocolate syrup is -.3. The store is advertising a sale with ice cream prices reduced by 20%.

  • Linear Programming

    In January, the company produced 15,000 windows and ended the month with 9000 windows in inventory. EZ-Windows management team would like to develop a production schedule for the next three months.

  • Calculating gross margin and total direct manufacturing cost

    The remaining items are general and administrative expenses (fixed costs).

View More Related Solutions