Company Simple Laminates brothers Inc. is producing impregnated papers for the furniture industry. Following information of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Company Simple Laminates brothers Inc. is producing impregnated papers for the furniture industry. Following information of the parts of the product. Material base Product Plastic Melamine Phenol Pallets Paper Melamine resin Phenolic resin Packaging Direct Material Impregnated paper units 70gr 70gr 65gr 1 cost per Kg 3 2,25 2,15 50 cost per 4500 Melamine Phenol product product sqm cost per sqm 0,21 0,1575 90 0,02 0,3875 0,21 0,13975 0,018 0,36775 In order to produce the products, the company has 6 direct employees per shift preparing impregnated papers at an annual cost of 30.000€ per employee. The employees have a working schedule of 1750 hours per year. The production site works with a 3-shift schedule, 24 hours per day. To coordinate the production we have a foreman, with a total annual cost of 50.000€ per year. If there is a need for more direct labor the company has the chance to use overtime with the existing employees at actual cost per hour with an increase of 50%. The production facility has two production lines operated by 3 employees each at the same time. The company pays a rent for the production hall of 5.000€ per month, and the utilities expenses are expected to be of 500€ per month, fixed and a variable cost of 0,005€ per sqm. The sales organization has one customer service with an annual cost of 33.500€, and the support of an external agent that takes a 5% commission over sales. The administration of the company has two persons in the accounting department, with an annual cost of 25.000€ each. The machines run at 50 linear meters per minute, and the product has a width of 2 meters. Our quarterly sales budget for 2019 is: Unit sales melamine Unit sales phenol Q1 Q distribution % of sales Production days according to calendar 7.776.000 7.698.240 Q1 Q2 65 02 2019 03 11.289.600 11.016.000 1.140.250 10.795.680 The sales price for melamine products is 45cents, and the price for the phenolic is 40 cents. This is the production calendar that the company has agreed with its union. 70 2019 Q3 04 65 04 Total 741.600 30.823.200 763.848 20.398.018 18,75 Total 218,75 1.- Prepare a Quarterly budget for the year 2019, taking into consideration that you have to prepare first a production scheduling. Beginning inventory is 1.000.000 units, and the desired ending inventory for the end of the first Q 900.000, at the end of the Q2 800.000, at the end of Q3 600.000 and 1.000.000 at the end of the year 2019. The company has an agreement with the unions that allows them to use overtime on every month that they have a lack of capacity to fulfill the market demand. 2.- Do you think you should change your production calendar to improve your results? Prepare a new production schedule that maximizes the company results. Prepare a Quarterly budget in line with the "adjusted" budget. 3.- For the year 2020, the market situation has changed, Phenol sales units drop 1.000.000 every quarter compared to 1919 and melamine products increase in 1.500.000 every quarter. Raw materials cost has also changed both melamine and phenol resins have a prices per Kg of 2€. Company Simple Laminates brothers Inc. is producing impregnated papers for the furniture industry. Following information of the parts of the product. Material base Product Plastic Melamine Phenol Pallets Paper Melamine resin Phenolic resin Packaging Direct Material Impregnated paper units 70gr 70gr 65gr 1 cost per Kg 3 2,25 2,15 50 cost per 4500 Melamine Phenol product product sqm cost per sqm 0,21 0,1575 90 0,02 0,3875 0,21 0,13975 0,018 0,36775 In order to produce the products, the company has 6 direct employees per shift preparing impregnated papers at an annual cost of 30.000€ per employee. The employees have a working schedule of 1750 hours per year. The production site works with a 3-shift schedule, 24 hours per day. To coordinate the production we have a foreman, with a total annual cost of 50.000€ per year. If there is a need for more direct labor the company has the chance to use overtime with the existing employees at actual cost per hour with an increase of 50%. The production facility has two production lines operated by 3 employees each at the same time. The company pays a rent for the production hall of 5.000€ per month, and the utilities expenses are expected to be of 500€ per month, fixed and a variable cost of 0,005€ per sqm. The sales organization has one customer service with an annual cost of 33.500€, and the support of an external agent that takes a 5% commission over sales. The administration of the company has two persons in the accounting department, with an annual cost of 25.000€ each. The machines run at 50 linear meters per minute, and the product has a width of 2 meters. Our quarterly sales budget for 2019 is: Unit sales melamine Unit sales phenol Q1 Q distribution % of sales Production days according to calendar 7.776.000 7.698.240 Q1 Q2 65 02 2019 03 11.289.600 11.016.000 1.140.250 10.795.680 The sales price for melamine products is 45cents, and the price for the phenolic is 40 cents. This is the production calendar that the company has agreed with its union. 70 2019 Q3 04 65 04 Total 741.600 30.823.200 763.848 20.398.018 18,75 Total 218,75 1.- Prepare a Quarterly budget for the year 2019, taking into consideration that you have to prepare first a production scheduling. Beginning inventory is 1.000.000 units, and the desired ending inventory for the end of the first Q 900.000, at the end of the Q2 800.000, at the end of Q3 600.000 and 1.000.000 at the end of the year 2019. The company has an agreement with the unions that allows them to use overtime on every month that they have a lack of capacity to fulfill the market demand. 2.- Do you think you should change your production calendar to improve your results? Prepare a new production schedule that maximizes the company results. Prepare a Quarterly budget in line with the "adjusted" budget. 3.- For the year 2020, the market situation has changed, Phenol sales units drop 1.000.000 every quarter compared to 1919 and melamine products increase in 1.500.000 every quarter. Raw materials cost has also changed both melamine and phenol resins have a prices per Kg of 2€.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
In order to produce its new line of canned foods, Hammond Foods must purchase a specialized piece of equipment that has the capacity to fill a million cans annually. Suppose Hammond plans to...
-
Crimson Wheels Bus Company produces buses In order to produce the seats for the buses, special equipment must be set up The setup cost per frame is $20 The cost of carrying seats in inventory is $5...
-
Why must an air mass rise in order to produce precipitation?
-
In Exercises show that the two formulas are equivalent. tan x dx = - In cos x + C tan x dx = In|sec x] + C
-
In alpha testing a new software package, a software engineer finds that the number of defects per 100 lines of code is a random variable X with probability distribution: Find (a) Pr(X > 1). (b) Pr(X...
-
Use each map shown. (a) Represent the map as a graph. Use the letter indicated in parentheses to label vertices of the graph. (b) Determine (state yes or no) whether the graph in part (a) has an...
-
Defendant Kenneth Blake was married to Charlene Hinton-Blake, who died in 2012. Three of Hinton-Blakes sisters, including Yvonne Hinton, assisted her with day-to-day care during a four-year period of...
-
Ialani Corp. uses a job order costing system for the yachts it constructs. On September 1, 2010, the company had the following account balances: Raw Material Inventory ........ $332,400 Work in...
-
A firm selling a normal good has a price elasticity of demand coefficient of 3.0 and an income elasticity of demand coefficient of 2.2. Assume that economists forecast a recession within the next...
-
Not surprisingly, Tarek still has several thousand dollars in student loans outstanding. When he graduated from college, he had federal loans of $48,100, with an average APR of 5.40%. Six months...
-
The process of strategic can be complex. As the purchasing manager, how would you strategically source the appropriate fabric for a garment at Mango? Strategic Sourcing Main examination (1).pdf...
-
On December 31, 2022, Figg Company reported net sales revenue of $155,000, gain on the sale of equipment of $2,000, rent revenue of $4,000, and rent expense of $5,000. What would be reported as other...
-
Scott's Car Storage rents storage space for customers' cars during the winter months. The service costs $600 per car for the six-month period of October through March, with payment due up-front....
-
________________ accounting reports info mainly at the end of the month, quarter, or year. Select one: a. Managerial b. There is not enough information to answer this question. c. Both Financial and...
-
Stacey owned all of the sock in small inc., a calendar year taxpayer, until april 30 when she sold it all to Andrew. Small made the following distributions during the year, april 1 $350,000 to stacey...
-
What would be the gains from additional supply made available (at the same price) from each of the growers? How much of a premium would you be willing to pay for each additional box and how many...
-
ABC Company supplies replacement ink cartridges for printers. Daily demand for their cartridges averages 100 units, with a standard deviation of 4 units. The holding cost of the cartridge is $55 per...
-
Using Apple, demonstrate how the differentiation strategy can be well implemented.
-
Suppose the demand and supply curves for a product are given by Q D = 500 - 2P Q S = -100 + 3P a. Graph the supply and demand curves. b. Find the equilibrium price and quantity. c. If the current...
-
Suppose a firm has a constant marginal cost of $10. The current price of the product is $25, and at that price, it is estimated that the price elasticity of demand is 3.0. a. Is the firm charging the...
-
The individual demand for a slice of pizza at Sam's Pizza is given by Q D = 6 - P. Assume the marginal cost of a slice is constant at $1.00 and the marginal revenue (MR) function is 6 - 2Q. a. What...
-
In the case considered in the question (14), show what the trajectory corresponds to in case the magnitude of acceleration is \(a=2 k \sqrt{1+\frac{t}{T}}\), where \(T=\) cost. Question 14 A particle...
-
The position vector along a trajectory expressed in terms of the scalar distance \(s\) from the origin is given by the relation \(\mathbf{r}=\mathbf{a} s^{2}+\mathbf{b} s+\mathbf{c}\), with the...
-
A particle is constrained to move on a circular guideway of radius \(R=3.00 \mathrm{~m}\), on which it can slide without friction, according to the motion equation law \(s(t)=k t^{3}\), with \(k=2.0...
Study smarter with the SolutionInn App