1. Last year's sales for the 6-month period of February to July were $589,345. A 5...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Last year's sales for the 6-month period of February to July were $589,345. A 5 percent increase in sales is anticipated this year. Total reductions for the period are planned at 8 percent. The initial markup is planned at 53.9 percent. The buyer desires an ending inventory of $190,000 for the period. Based on an analysis of past sales records and current market trends, the buyer has also made plans for the period in relation to (1) monthly distribution of sales, (2) monthly stock- to-sales ratios, and (3) monthly distribution of planned reductions. These three planning estimates for each month are as follows: Month Feb Mar Apr May June July Sales Distribution 10% 10% 35% 20% 15% 10% Stock-to-Sales Ratio 2.4 2.4 2.1 2.0 2.0 2.0 Reductions Distribution 5% 5% 10% 20% 30% 30% Calculate (1) planned monthly sales, (2) planned monthly BOM, (3) planned monthly EOM, (4) planned monthly reductions, (5) planned purchases at retail, and (6) planned purchases at cost. 1. Last year's sales for the 6-month period of February to July were $589,345. A 5 percent increase in sales is anticipated this year. Total reductions for the period are planned at 8 percent. The initial markup is planned at 53.9 percent. The buyer desires an ending inventory of $190,000 for the period. Based on an analysis of past sales records and current market trends, the buyer has also made plans for the period in relation to (1) monthly distribution of sales, (2) monthly stock- to-sales ratios, and (3) monthly distribution of planned reductions. These three planning estimates for each month are as follows: Month Feb Mar Apr May June July Sales Distribution 10% 10% 35% 20% 15% 10% Stock-to-Sales Ratio 2.4 2.4 2.1 2.0 2.0 2.0 Reductions Distribution 5% 5% 10% 20% 30% 30% Calculate (1) planned monthly sales, (2) planned monthly BOM, (3) planned monthly EOM, (4) planned monthly reductions, (5) planned purchases at retail, and (6) planned purchases at cost.
Expert Answer:
Answer rating: 100% (QA)
To calculate the planned monthly sales we need to apply the sales distribution percentages to the total sales for the period Planned Monthly Sales Total Sales x Sales Distribution Planned Monthly Sale... View the full answer
Related Book For
Managerial Accounting An Introduction to Concepts Methods and Uses
ISBN: 978-0324639766
10th Edition
Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil
Posted Date:
Students also viewed these finance questions
-
A 5 percent increase in the price of digital apps reduces the amount of tablet devices demanded by 3 percent. What is the cross price elasticity of demand? Are tablet devices and digital apps...
-
A departments maintained markup is 38 percent, reductions are $560, and net sales are $28,000. Whats the initial markup percentage?
-
This exercise is based on four different inventory relation schemas: P, Q, R, and S. An instance of each relation schema is given below, each of which reflects a different design objective. a....
-
The following are selected transactions of Bridgeport Department Store Ltd. for the current year ended December 31. Bridgeport is a private company operating in the province of Manitoba where PST is...
-
The demand for an item is constant at 100 units a year. Unit cost is 50, the cost of processing an order is 20 and holding cost is 10 a unit a year. What are the economic order quantity, cycle length...
-
What is the total factory overhead allocated per unit of Dings? Aleutian Company produces two products: Rings and Dings. They are manufactured in two departments: Fabrication and Assembly. Data for...
-
Calculate the interquartile range for each of the following sets of data: a. \(3,6,7,12,15,17,23,28\) b. \(8,4,1,6,13,10,12,5\) c. \(3,8,14,11,16,7,14,15,11,9,12,6\) d....
-
Super Clean, Inc. produces and sells stain remover. Information about the budget for the year 2012 is as follows: 1. The company expects to sell 50,000 bottles of stain remover in the first quarter,...
-
The David Derrick Insurance company wants to sells a certain policy for $1000 to John Graham Jr. They know from historic data that there is a 1 in 100 chance John will file a $20,000 claim, a 1 in...
-
As Mel Smith was doing his year-end accounting, he noticed that the bookkeeper had made errors in recording several transactions. The erroneous transactions are as follows: (a) A check for $700 was...
-
According to Modigliani and Miller, in a perfect capital market, the value of a firm increases when it increases its debt-to-equity ratio. Group of answer choices True False
-
Record each of the below transactions in general journal form for Kingston Bank. June 15: Owners started the banking business by depositing $2,000,000 received from the sale of capital stock. June...
-
In the game of Golf, golfers have a collection of tools that they used to get the golf ball from the tee box to the hole. These tools are called golf clubs. A golfer is allowed to carry these clubs...
-
Figure 16.1 Source regions for air masses that influence North America. mP Maritime polar Cool, humid mT Maritime tropical Warm, humid cP Continental polar Cold, dry CT Continental tropical Hot,...
-
For a roof of 10,000 sqf there exist 3 alternatives that are shown in the table. Study period=40 yrs and discount rate=3%. Energy (Heating fuel) cost is $3 per gal. Replacement of roof is $4.6 per...
-
1. Answer the following questions about the graph in Figure 1: a. Find the degrees of the vertices in the graph. b. Does the graph have an Closed Eulerian Trail (Euler Tour)? If so, write such a...
-
James owns a home in Lake Tahoe, Nevada, that he rented for $5,100 for 40 days during the summer. He lived there for a total of 120 days, and the rest of the year, the house was vacant. The expenses...
-
Is that Yelp review real or fake? The article A Framework for Fake Review Detection in Online Consumer Electronics Retailers (Information Processing and Management 2019: 12341244) tested five...
-
What are the advantages of using the ROI measure rather than the value of division profits as a performance evaluation technique?
-
Refer to the Managerial Application Using the Basic Cost Flow Equation to Detect Fraud. How did the manager of the Gravins Division fraudulently increase profits? How was the fraud detected?
-
Almaden Bicycles has discovered a problem involving the welding of bicycle frames that costs the company $3,000 in waste and $1,500 in lost business per period. There are two alternative solutions....
-
What are the numbers of observations in each of the five categories that rate the respondents level of job satisfaction?
-
Which of the seven store departments had the most customer visits, and what was this number?
-
How many individuals are in each of the five different credit card categories?
Study smarter with the SolutionInn App