1 answer

Can you please show the work as well. Cash Budget The controller of Bridgeport Housewares Inc....

Question:

Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three mo1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positivecan you please show the work as well.

Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $111,000 $132,000 $179,000 Manufacturing costs 47,000 57,000 64,000 Selling and administrative 39,000 40,000 68,000 expenses Capital expenditures 43,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of $42,000, marketable securities of $60,000, and accounts receivable of $123,700 ($97,000 from July sales and $26,700 from August sales). Sales on account for July and August were $89,000 and $97,000, respectively. Current liabilities as of September 1 include $10,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $16,000 will be made in October. Bridgeport's regular quarterly dividend of $10,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $41,000.
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations. Bridgeport Housewares Inc. Cash Budget For the Three Months Ending November 30 September October November Estimated cash receipts from: Cash sales I1,100 13,20 17,90 V Collection of accounts receivable 83.490 X 87,990X 130,200 х 105,890X $141,300 X 96,690X Total cash receipts Less estimated cash payments for Other purposes: Total cash payments $ Cash balance at end of month $ Excess or (deficiency)

Answers

Solution 1:

Computation of Collection from Customer
Particulars September October November
Collection for July Sales $26,700.00
Collection for August Sales $67,900.00 $29,100.00
Collection for September Sales $69,930.00 $29,970.00
Collection for October Sales $83,160.00
Total cash collections $94,600.00 $99,030.00 $113,130.00
Computation of Cash payment of manufacturing costs
Particulars September October November
Payment for August Manufacturing cost $10,000.00
Payment for September Manufacturing cost $29,600.00 $7,400.00
Payment for October Manufacturing cost $37,600.00 $9,400.00
Payment for November Manufacturing cost $43,200.00
Total cash disbursements $39,600.00 $45,000.00 $52,600.00
Bridgeport Housewares Inc.
Cash Budget
For the Three Months Ending November 30
Particulars September October November
Estimated cash receipts from:
Cash sales $11,100.00 $13,200.00 $17,900.00
Collection of accounts receivable $94,600.00 $99,030.00 $113,130.00
Total cash receipts $105,700.00 $112,230.00 $131,030.00
Less estimated cash payments for:
Manufacturing costs $39,600.00 $45,000.00 $52,600.00
Selling and administrative expenses $39,000.00 $40,000.00 $68,000.00
Capital expenditures $43,000.00
Other purposes:
Income tax $16,000.00
Dividends $10,000.00
Total cash payments $78,600.00 $101,000.00 $173,600.00
Cash increase or (decrease) $27,100.00 $11,230.00 -$42,570.00
Plus cash balance at beginning of month $43,000.00 $70,100.00 $81,330.00
Cash balance at end of month $70,100.00 $81,330.00 $38,760.00
Less minimum cash balance $41,000.00 $41,000.00 $41,000.00
Excess or (deficiency) $29,100.00 $40,330.00 -$2,240.00
.

Similar Solved Questions

1 answer
Consider the following observations on a receptor binding measure (adjusted distribution volume) for a sample of...
Consider the following observations on a receptor binding measure (adjusted distribution volume) for a sample of 13 healthy individuals: 22, 39, 40, 41, 43, 48, 52, 59, 62, 67, 68, 69, 72. (a) Is it plausible that the population distribution from which this sample was selected is normal? ---Select--...
1 answer
During its first year of operations, the McCormick Company incurred the following manufacturing costs: Direct materials,...
During its first year of operations, the McCormick Company incurred the following manufacturing costs: Direct materials, $4 per unit, Direct labor, $3 per unit, Variable overhead, $3 per unit, and Fixed overhead, $342,000. The company produced 38,000 units, and sold 29,500 units, leaving 8,500 units...
1 answer
If f(x)=3x-1 and g(x)=2x-1 what is fg(6)=289?
If f(x)=3x-1 and g(x)=2x-1 what is fg(6)=289?...
1 answer
[email protected] #11 RS and Nomenclature Word O Tell me what you want to do Help Review...
[email protected] #11 RS and Nomenclature Word O Tell me what you want to do Help Review View Mailings References Layout Set #11 RS Notation and Nomenclature 1. Name each of the following molecules following IUPAC system of nomenclature. Include E and Z where applicable. Also, include R and S...
1 answer
Draw diagrams that represents 1.Centripetal force, centrifugal force, radius, tangential velocity, the arc length, angular momentum...
Draw diagrams that represents 1.Centripetal force, centrifugal force, radius, tangential velocity, the arc length, angular momentum angular velocity 2.What is torque? What equation represents it?! 3. When is torque the strongest and weakest? 4. At what angles is the torque is the strongest and weake...
1 answer
Problem #2 Identify compounds A through J in the following scheme: D NHS NaOACETOH рут. A...
Problem #2 Identify compounds A through J in the following scheme: D NHS NaOACETOH рут. A (Pn)Culi, E H?C=PPh F рут. LAH LIAI (OIBU)3H CH, Mgl (xs) 1. PBrz. pyr. (xs) G 1.Pr.PY, H 3. H,O*, A...
3 answers
A) Determine an equation, in simplified form, for the family of cubic functions with zeros 2 +- sqrt5 and 0
a) Determine an equation, in simplified form, for the family of cubic functions with zeros 2 +- sqrt5 and 0.b) Determine an equation for the member of the family with graph passing through point (2,20)...
1 answer
Part B: Post the Journal Entries you made in Part A to the appropriate T-Accounts found...
Part B: Post the Journal Entries you made in Part A to the appropriate T-Accounts found in Part B. Your T-Account entries must be properly linked to the Journal Entry amounts you entered in Part A. The first T-Account posting has been done for you. ALSO, provide calculations at the bottom of the T-A...
1 answer
7. A low concentration of NTA has equilibrated with PbCO3(s) at pH 7.00 in a medium...
7. A low concentration of NTA has equilibrated with PbCO3(s) at pH 7.00 in a medium having a final HCO3- concentration of 7.50x10-4 M. a. Determine [Pb2+]. b. Write out KT and the overall reaction for KT. c. What is the ratio of [Pb(NTA)- ] to [H(NTA)2-] in this solution? Potentially useful data: R...
1 answer
1. Give examples of sample statistic and population parameter. 2. Give some properties of any normal...
1. Give examples of sample statistic and population parameter. 2. Give some properties of any normal distribution. 3. What is the total area under a normal distribution curve? 4. What is the mean and standard deviation of standard normal distribution? 5. what percentage of the area under the normal ...
1 answer
HOW MANAGER MAKES THINGS HAPPEN IN DECISION MAKING PROCESS. write at least 100 words to justify...
HOW MANAGER MAKES THINGS HAPPEN IN DECISION MAKING PROCESS. write at least 100 words to justify your thoughts...
1 answer
QUESTION 13 Which of the following best describes acclimation? o long-term physiological adjustment to an abrupt...
QUESTION 13 Which of the following best describes acclimation? o long-term physiological adjustment to an abrupt change in environmental conditions short-term metabolic and long-term physiological adjustment to environmental changes long-term metabolic and short-term physiological adjustment to envi...
1 answer
1 Semiquantitative Results Using Semiclassical Quantization In this problem, you will analyze the consequences of the...
1 Semiquantitative Results Using Semiclassical Quantization In this problem, you will analyze the consequences of the de Broglie relations (i.e., Bohr-Sommerfeld quantization) on the motion of particles in the same potential as in Problem 3 of Problem Set #3, V(r) = v. ()°. (1) 1.1 Classical orb...
1 answer
Help with all please 46. The dashed line that separates crust from uppermost manitleis Due on...
Help with all please 46. The dashed line that separates crust from uppermost manitleis Due on Wed, 8 May 19 a. ecotone b. lithopause c. Mohorovicic discontinuity ("Moho d. lithification zone mantle is known as the: described as a: a. Convergent plate boundary b. Divergent plate boundary C. Trans...
1 answer
If p is a Turing machine then L(p) = {x | p(x) = yes}. Let A...
If p is a Turing machine then L(p) = {x | p(x) = yes}. Let A = {p | p is a Turing machine and L(p) is a finite set}. Is A computable? Justify your answer...
1 answer
Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially...
Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Calculate the three-period moving-average forecast for periods 4 through 10. Calculate the weighted mov...
1 answer
Using the line drawing tool, draw a line showing a direct relationship between money supply and...
Using the line drawing tool, draw a line showing a direct relationship between money supply and the money base. Label the line 'Direct'. Carefully follow the instructions above, and only draw the required objects. Money Supply og i į į į Ś Money Base & į ¢ &...