1 answer

The St Germaine Company is preparing its cash payments budget. The following items relate to cash...

Question:

The St Germaine Company is preparing its cash payments budget. The following items relate to cash payments the company antici

The St Germaine Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. (Click the icon to view the cash payment information.) Requirement Prepare a cash payments budget for April, May, and June and for the quarter. a box is not used in the table leave the box empty, do not enter a zero.) Х More Info The St. Germaine Company Cash Payments Budget For the Months of April through June May Cash payments for direct materials: 55% of current month purchases 45% of last month's purchases April June Quarter a. The company pays for 55% of its direct materials purchases in the month of purchase and the remainder the following month. The company's direct material purchases for March through June are anticipated to be as follows: March April May June $ 116,000 $ 132,000 $ 126,000 $ 147,000 b. Direct labor is paid in the month in which it is incurred. Direct labor for each month of the second quarter is budgeted as follows: April May June $ 60,000 $ 70.000 $ 85,000 c. Manufacturing overhead is estimated to be 160% of direct labor cost each month. This monthly estimate includes $32,000 of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred. d. Monthly operating expenses for March through June are projected to be as follows: March April May June 77,000 $ 83.000 $ 89,000 $ 92,000 Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $15,000 for monthly depreciation on administrative offices and equipment, and $3,000 for bad debt expense. e. The company plans to pay $8,000 (cash) for a new server in May. f. The company must make an estimated tax payment of $14,000 on June 15. EA Print Done Enter any number in the edit fields and then click Check Answer

Answers

Answer:

The St. Germaine Company
Cash Payments Budget
For the Months of April through June
April May June Quarter
Cash payments for direct materials:
      55% of current month purchases $      72,600 $      69,300 $      80,850 $      2,22,750
      45% of last month's purchases $      52,200 $      59,400 $      56,700 $      1,68,300
Cash payments for direct labors: $      60,000 $      70,000 $      85,000 $      2,15,000
Total $   1,84,800 $   1,98,700 $   2,22,550 $      6,06,050

Working note:

Direct materials purchase Payment in April Payment in April Payment in May Payment in May Payment in June Payment in June
Month % $ % $ % $
(i) (ii) (iii)[(i)*(ii)] (iv) (v)[(i)*(iv)] (vi) (vii)[(i)*(vi)]
March $   1,16,000 45% $      52,200 $                 -   $                  -  
April $   1,32,000 55% $      72,600 45% $        59,400 $                  -  
May $   1,26,000 $               -   55% $        69,300 45% $         56,700
June $   1,47,000 $               -   $                 -   55% $         80,850
TOTAL $   4,05,000 $   1,24,800 $     1,28,700 $     1,37,550

Payment criteria:

55% in same month & 45% in next month of direct material purchases.

Direct labor is paid in the month which it is incurred.

.

Similar Solved Questions

1 answer
10200 6100 No answer text provided. 013 19 The net realizable value of accounts receivable is...
10200 6100 No answer text provided. 013 19 The net realizable value of accounts receivable is the full amount owed by customers. True False Dg 14 19 The Allowance for Uncollectible Accounts is a contra asset account representing the amount of accounts receivable that we do not expect to collect. Tru...
1 answer
Post a novel and appropriate response to the question(s) posed Most of us sell our labor...
post a novel and appropriate response to the question(s) posed Most of us sell our labor for wages, which provides us with an income to support our spending, saving, and investing. One way to maximize the value of your labor is to improve your ability to sell yourself to employers. Education is one ...
1 answer
In the following Finite Accepters the initial state is indicated by the label "start", and any...
In the following Finite Accepters the initial state is indicated by the label "start", and any final states are indicated by their box being checked as shown below start so inital state final state Given the following Finite Accepter which of the following strings will be accepted? s0 s2 sta...
1 answer
1. Solve the maximization problem: mary = 29.252.0,75 s.t.100 – 2.11 - 4.02 = 0 (1)...
1. Solve the maximization problem: mary = 29.252.0,75 s.t.100 – 2.11 - 4.02 = 0 (1) 2. Suppose that Jeff cares only about basketball (B) and football (F). His utility function is U = B04F0.6The price of a basketball ticket is $5, and the price of a football ticket is $10. Jeff has a budget of ...
1 answer
A painter of mass 50.0 kg stands on a platform of mass 60.0 kg and pulls...
A painter of mass 50.0 kg stands on a platform of mass 60.0 kg and pulls on two ropes which hang over pulleys, as shown. He pulls each rope with a force of 800.0 N. Assuming a coordinate system where +y is up, calculate the y-component of the acceleration ay. ay can either be positive or negative de...
1 answer
1A) A large supermarket carries four qualities of ground beef. Customers are believed to purchase...
1A) A large supermarket carries four qualities of ground beef. Customers are believed to purchase these four varieties with probabilities of 0.13, 0.16, 0.13, and 0.58, respectively, from the least to most expensive variety. A sample of 482 purchases resulted in sales of 46, 151, 88, and 197 of the ...
1 answer
Show all work: Stanley Co intends to have a cash flow of $45 million for the...
Show all work: Stanley Co intends to have a cash flow of $45 million for the next year. The organization's rate of return is 10%. Cash flows are expected to grow at 5% indefinitely. If the company has $100,000,000 in debt and 50,000,000 shares, what is the value of the firm when using the consta...
2 answers
DDT is stored in body fat and remains toxic for many years
DDT is stored in body fat and remains toxic for many years. Explain why these characterestics are undersirable in a pesticide. What characteristics would you want in a pesticide to make it less harmful to non-pest organisms?...
1 answer
Name of the term which means inflammation   of the cervix
name of the term which means inflammation   of the cervix...
1 answer
55) 55) A benchmark index has three stocks priced at $23, S43 and $56 yesterday. The...
55) 55) A benchmark index has three stocks priced at $23, S43 and $56 yesterday. The number of outstanding shares for each is 350,000 shares, 405,000 shares and 553,000 shares, respectively. If the market value weighted index was 970 yesterday and the prices changed to $23, S41 and $58 today, what i...
1 answer
A business manager wanted to know if there was a relationship between daily temperature measured in...
A business manager wanted to know if there was a relationship between daily temperature measured in degrees Fahrenheit and number of employees who called-in sick each day. He collected the following data over 10 days: Daily Temperature: 64 60 67 63 60 64 72 66 60 69 # Called-in Sick: 33 32 30 37 34 ...
1 answer
Sodium hydroxide can be produced by electrolysis of NaCl solution 2NaCl(aq)   +   2 H2O(l)     à 2...
Sodium hydroxide can be produced by electrolysis of NaCl solution 2NaCl(aq)   +   2 H2O(l)     à 2 NaOH(aq)    +    H2(g)      +   Cl2(g)      A 100 g of 20 % aque...
1 answer
2. Por the system shown below with G- K(s + 2)(s + 20), G,-1/(s (s-4), and...
2. Por the system shown below with G- K(s + 2)(s + 20), G,-1/(s (s-4), and H리 Controller Plant C Fig. 1 (a) (5%) Sketch a root-locus plot for the system (K varies from 0 to o) (b) (10%) Determine center and angle of asymptotes....
1 answer
MC Qu. 23 C&A manufactures treats for dogs... C&A manufactures treats for dogs. Six samples each...
MC Qu. 23 C&A manufactures treats for dogs... C&A manufactures treats for dogs. Six samples each of five bags of treats were randomly selected and weighed, yielding the following data 2 11.8 11.2 8.8 6.5 8.6 7.3 3 10.1 12.4 7.6 12.5 10.3 5.9 4 5.9 7.6 11.3 10.4 11.8 10.8 5 8.6 5.9 9.9 6.9 10...
1 answer
Building molecular models #of Electron Dot Model Valence Form 3D shape Central Atom Molecular Electron Molecular...
building molecular models #of Electron Dot Model Valence Form 3D shape Central Atom Molecular Electron Molecular Geometry Formula CH4 CH2CI2 Н.0. NH3...
1 answer
- 20 40 Composition (at"% Sn) 60 327°C Liquid 500 232°C 183°C Temperature (°C) Temperature (°F)...
- 20 40 Composition (at"% Sn) 60 327°C Liquid 500 232°C 183°C Temperature (°C) Temperature (°F) 19.3 61.9 20 60 80 100 (Sn) Composition (wt% Sn) A lead-tin alloy of composition Pb-30%Sn is slowly cooled from a temperature of 300°C. Use the phase diagram given to determine...
1 answer
1. Calculate the standard cell potential cell that uses the Mg/Mg2+ and Cu/Cu* half- cell reactions...
1. Calculate the standard cell potential cell that uses the Mg/Mg2+ and Cu/Cu* half- cell reactions at 25°C. Write the equation for the cell reaction that occurs under standard-state conditions....