Please answer quick in an hour. Next, plan monthly EOM stock for each month.Ending inventory for the season is planned at $43,000.C.6. Prepare a six-month merchandise plan based onthe information presented below. Planned sales areexpected to be the same as last year.d. Now, plan purchases at retail. Then, convert thiafigure to cost. The initial markuP percentage is plannedMonthLast YearLast Yearat 46.4 percent.Monthly SalesBOM Stock7. A small business places reorders every two weeksOnce orders are placed, four weeks are typicallyrequired for delivery. The weekly sales rate of an itemis 30. Calculate the maximum.February$12,000$25,000March$14,000$30,000April$18,000$38,000May$19,000$40,000June$18,000$39,0008. Planned purchases at cost for the month of Februaryare $21,000. Two purchase orders are outstanding. Thefirst is for $550, and the second is for $2,150. What isthe open-to-buy?July$19,000$41,000Calculate last year's monthly stock-to-sales ratiosa.and plan monthly BOM inventory levels.9. Planned purchases for the month of March are $27,500.Three purchase orders are outstanding. The first is for$1,100, the second is for $20,000, and the third is for$6,600. What is the open-to-buy?b. Now, plan monthly reductions for the period.Reductions are planned at 8 percent and will bedistributed as follows:February10%March5%April5%May15%June30%July35%

Answer 7 The duration between orders equals the optimal order size divided by annual demand. The…

Answered: 7. A small business places reorders…

7. A small business places reorders every two weeks Once orders are placed, four weeks are typicall; required for delivery. The weekly sales rate of an item is 30. Calculate the maximum.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
Please answer A-C with the most true answer. A. Which of the following is most closely associated with return on assets? a. The cost of equity b. The proportion of debt and equity in the company’s capital structure c. The prime lending rate d. The average operating assets of the company B. Which of the following is most closely associated with expenses? a. Product (value propositions) design(s) b. Average operating assets c. Proportion of debt and equity in the company’s capital structure d. Equity risk premium C. Which of the following is most closely associated with the cost of debt? a. Non-operating expenses b. Risks specific to the company c. The long-term bond yield d. Prime lending rate
Which of the following is most controllable by company management? a. The environmental factors, particularly the competitive and economic factors b. The elasticity of demand c. The proportions of debt and equity used to finance the company’s assets d. The long-term bond yield and the equity risk premium
Retailer Budget D. Tomlinson Retail seeks your assistance in developing cash and other budgetinformation for May, June, and July. The store expects to have the following balances at the end ofApril:Cash $ 5,500Accounts receivable 437,000Inventories 309,400Accounts payable 133,055The firm follows these guidelines in preparing its budgets:∙ Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day ofeach month. The firm books receivables at gross amounts and collects 60% of the billings withinthe discount period, 25% by the end of the month, and 9% by the end of the second month. Thefirm’s experience suggests that 6% is likely to be uncollectible and is written off at the end of thethird month.∙ Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month’s units of endinginventory should equal 130% of the next month’s cost of sales. The…
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
SLO-3.1 The major reason supply management can greatly improve a firm’s return on investment (ROI) is: A) the reduction of post ownership costsB) the reduction of downtime costsC) the reduction of quality costsD) the reduction of acquisition costE) every dollar saved in purchasing is = to a new dollar of profit NEWSLO-3.2 Which of the following is generally not true about supply management and the bottom line? A) Purchased items account for a large percentage of the cost of goods sold. Hence, a reduction in cost of purchased goods has a major impact on the bottom lineB) A Euro increase in sales is equivalent to a Euro decrease in materials cost in impacting the bottom lineC) Outsourcing allows firms to focus on their core competencies, which reduced potential for waste, which then can improve the bottom lineD) A dollar saved in materials cost is usually considered a dollar increase in profit, which directly translates into bottom line savingsE) Supply management can work…
What is the relationship betweenthe process of standard cost variance analysis and management by exception?
May Clothing is a retail men’s clothing store. May’s variable cost is $20 per shirt and the sales price is$40 per shirt. May plans to sell 400,000 shirts for the year and, at this level, would generate a beforetax profit of $2,500,000. What is the degree of operating leverage (DOL) at this volume level?
1. Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? * a. 2.50 b. 225,000 c. 10,000 d. 250,000 e. 25,000 2. Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s sale volume variance to assess how the variance affect the total profit. * a. 11,250 b. 1,500 c. 9,000 d. 2,250
Abduallh, the Internal auditor of TATI Company recommends to the top management about the need for using stock tracking software to ensure effective store management. Which of the following statement holds true about the above statement? a. It’s an example of Whistle blowing since it is reported to the top Management b. It is not an example of Whistleblowing since there is no wrongdoing reported c. It’s an example of Whistle blowing since it is an internal matter of the business d. It’s an example of whistle blowing since it is to protect the company’s best interest