Helsen, inc, manufactures lampshades the company is now preparing detailed budgets for the third quarter and has
Fantastic news! We've Found the answer you've been seeking!
Question:
Helsen, inc, manufactures lampshades the company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation.
a. The marketing department has estimated unit sales as follows for the remainder of the year:
July 18,000 October 23,000
August 20,000 November 21,000
September 25,000 December 18,000
The selling price of the lamp shades is $18 per unit.
Transcribed Image Text:
3. Prepare a material purchases budget for PTX, by month and for total, for third quarter. Also prepare a b. All sales are on credit. Based on the past experience, sales are collected in the following pattern: 20 % In the month of sales In the month following sale uncollectible 76% 4% Sales for June totaled $420,000. The company maintains finished goods inventories equal to 30% of the following month's sales. This requirement will be met at the end of June. d. Each lamp shades require 2.0 feet of PTX, a material that is sometimes hard to get. Therefore, the company requires that the inventory of PTX on hand at the end of each month be equal to 40% of the following month's production needs. The inventory of PTX on hand at the beginning and end of the quarter will be: 14,240 feet ? feet June 30 September 30 e. The PTX costs $5 per foot. 50% of a month's purchases of PTX are paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of PTX during June will be $91,000. Required: 1. Prepare sales budget, by month and in total, for the third quarter. (Show your budget in both unite dollar.) Also prepare a schedule of expected cash collections, by month and in total for ths and quarter. 2. Prepare a production budget for each of the months of July through October schedule of expected cash payments for PTX, by month and in total, for the third oe A 3. Prepare a material purchases budget for PTX, by month and for total, for third quarter. Also prepare a b. All sales are on credit. Based on the past experience, sales are collected in the following pattern: 20 % In the month of sales In the month following sale uncollectible 76% 4% Sales for June totaled $420,000. The company maintains finished goods inventories equal to 30% of the following month's sales. This requirement will be met at the end of June. d. Each lamp shades require 2.0 feet of PTX, a material that is sometimes hard to get. Therefore, the company requires that the inventory of PTX on hand at the end of each month be equal to 40% of the following month's production needs. The inventory of PTX on hand at the beginning and end of the quarter will be: 14,240 feet ? feet June 30 September 30 e. The PTX costs $5 per foot. 50% of a month's purchases of PTX are paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of PTX during June will be $91,000. Required: 1. Prepare sales budget, by month and in total, for the third quarter. (Show your budget in both unite dollar.) Also prepare a schedule of expected cash collections, by month and in total for ths and quarter. 2. Prepare a production budget for each of the months of July through October schedule of expected cash payments for PTX, by month and in total, for the third oe A
Expert Answer:
Answer rating: 100% (QA)
Helsin Company Sales Budget July August September Quarter Sales Units 16000 22000 24000 62000 Sellin... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
TAKULAH Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for the next five (5) months are: July 22,000 units Aug 50,000 units Sept 32,000 units Oct 26,000 units...
-
Pices Corporation has assembled the following information related to the purchase of a new automated postage machine: Using incremental analysis and only relevant information, compute the difference...
-
Aries Corporation has assembled the following information related to the purchase of a new automated postage machine: Using incremental analysis and only relevant information, compute the difference...
-
Case 2: First Year on the Job Joe finally received that job offer in the mail. He worked part-time for First Cirrus Bank during the spring semester and the work experience had paid off. Beginning on...
-
The same enzyme as in Problem 14 is studied in the presence of a different inhibitor (inhibitor B). In this case, two different concentrations of inhibitor are used. Data are as follows: a. What kind...
-
In 2014, Phoenix Corporation acquires a new research facility and hires several scientists to develop new products. No new products are developed until 2015, although the following expenditures were...
-
It can be shown that for any three events \(A, B\), and \(C\), the probability that at least one of them will occur is given by \[\begin{aligned} P(A \cup B \cup C)= & P(A)+P(B)+P(C) \\ & -P(A \cap...
-
The manager of a commuter rail transportation system was recently asked by her governing board to determine which factors have a significant impact on the demand for rides in the large city served by...
-
The y-intercept of the graph of the exponential function f(x) = 7.5(0.98)* is. Answer:
-
The woman A, the captain B, and the sailor C weigh 120, 180, and 160 lb, respectively, and are sitting in the 300-lb skiff, which is gliding through the water with a speed of 1 knot. If the three...
-
[12 marks] Dynamic programming In the NUGGETSINSWAMP problem, the input is an array W of n positive integers W[1], ..., W[n] representing the weights of nuggets lying on your path in a swamp. You...
-
1. A woman pushes a toy car (initially at rest, and of mass 0.1 kg) towards a child by exerting a constant force of 5 N through a distance of 0.4 m. What is: 1.1. the work done on the car? 1.2. the...
-
Question 2 10 pts Air in a hot air balloon does 37 J of work while expanding, and also absorbs 77.3 of heat from a heat source. What is the change in the balloon air's internal energy?
-
An ion having charge +6e is traveling horizontally to the left at 9.00 km/s when it enters a magnetic field that is perpendicular to its velocity and deflects it downward with an initial magnetic...
-
Each problem below refers to a vector V with magnitude [V] that forms an angle 0 with the positive x-axis. In each case, find the magnitudes of the horizontal and vertical vector components of V...
-
Current Attempt in Progress A planet has an equatorial radius of 4.93 107 m and a mass of 5.86 1026 kg. (a) Compute the acceleration of gravity at the equator of this planet. (b) What is the ratio...
-
(1) A part of an accountant's task is substantial involvement in setting financial targets and budgets within an organisation. Required: Describe how financial target setting can motivate employees...
-
What did Lennox gain by integrating their WMS, TMS, and labor management systems?
-
All transactions involving Notes Payable and related accounts of Pearl Company during 2010 are as follows: Determine the amount of the transactions affecting financing activities and show how they...
-
You recently attended a workshop on budgeting and overhead the following comments as you walked to the refreshment table: 1. Budgets are the same regardless of the size of an organization or...
-
Refer to the statement of cash flows in the CVS Corporation annual report in the Supplementary to Chapter 5 to answer the following questions: 1. Does CVS use the indirect method of reporting cash...
-
Based on the photographs in Figure 26.13, in which segment(s) is the Antp gene normally expressed? Figure 26.13: (a) Normal fly (b) Antennapedia mutant
-
The bush baby, a small African mammal, is a remarkable jumper. Although only about 8 inches long, it can jump, from a standing start, straight up to a height of over 7 feet! Use the particle model to...
-
Your friend Travis claims to have set the new world speed record for riding a unicycle. His top speed, he says, was 55 m/s. Do you believe him? Explain.
Study smarter with the SolutionInn App