1 answer

The Cabello Company buys air conditioners for $3,900 and sells them for $4,800 each; the company...

Question:

The Cabello Company buys air conditioners for $3,900 and sells them for $4,800 each; the company has the following sales fore
The company had cash of $22,000, equipment of $36,000 and zero accounts payable on April 1st. D1. What amount of cash would a
The Cabello Company buys air conditioners for $3,900 and sells them for $4,800 each; the company has the following sales forecast: April 120 units May 140 units June 180 units July 160 units The company wants to maintain ending inventory for each month at 15% of the next month's sales and had 20 units on hand on April 1st. The company also has monthly rent of $15,000 and salaries of $80,000. The company pays for 80% of inventory purchases in the month of the purchase and 20% of inventory purchases in the month following the purchase. Otherwise, it pays for all selling and administrative costs in the month incurred. The company's customers pay for all products in the month they are purchased. The company had cash of $22,000, equipment of $36,000 and zero accounts payable on April 1st.
The company had cash of $22,000, equipment of $36,000 and zero accounts payable on April 1st. D1. What amount of cash would appear in the company's balance sheet budget for May? Enter answer... D 2. What amount of accounts payable would appear in the company's balance sheet budget for April? Enter answer... D 3. What dollar amount of inventory would appear in the company's balance sheet budget for May? Enter answer...

Answers

April May June July
Sales forecast (units) 120 140 180 160
S.P $         4,800 $       4,800 $        4,800 $           4,800
Sales forecast ($) $   5,76,000 $ 6,72,000 $ 8,64,000 $     7,68,000
Sales forecast (units) 120 140 180 160
Ending inventory 21 27 24
Less:Opening inventory -20 -21 -27 -24
Purchases reqd 121 146 177
Purchase cost per unit $         3,900 $       3,900 $        3,900
Total Purchases $   4,71,900 $ 5,69,400 $ 6,90,300
Payment for
Current period purchases $   3,77,520 $ 4,55,520 $ 5,52,240
Previous period purchases 0 $     94,380 $ 1,13,880
Rent $      15,000 $     15,000 $     15,000 $        15,000
Salaries $      80,000 $     80,000 $     80,000 $        80,000
1)
Particulars April May
Opening balance of cash $      22,000 $ 1,25,480
Sales realization $   5,76,000 $ 6,72,000
Less:
Payment to suppliers $   3,77,520 $ 5,49,900
Rent $      15,000 $     15,000
Salaries $      80,000 $     80,000
Closing balance $   1,25,480 $ 1,52,580
Cash in Balance sheet for May is $ 1,52,580
2)
Question itself specifies that company has zero accounts payable as for April
3)
Closing inventory as at May 27
Purchase cost per unit $         3,900
Closing inventory as at May $   1,05,300

Please Like the solution if satisfied with the answer and if any query please mention it in comments...thanks

.

Similar Solved Questions

1 answer
Analyze each of the following pedigrees and indicate if the modes of inheritance are Autosomal recessive/dominant,...
Analyze each of the following pedigrees and indicate if the modes of inheritance are Autosomal recessive/dominant, X-linked recessive/dominant and explain in a few words. 10. Analy Autosomal recessive Autosomal dominant and explain why in a few words .X-linked recessive X-linked dominant 3 pts ea...
1 answer
A tangent-tangent angle intercepts two arcs that measure 135° and 225°. What is the measure of the tangent-tangent angle?
A tangent-tangent angle intercepts two arcs that measure 135° and 225°. What is the measure of the tangent-tangent angle?...
1 answer
Please write a full paragraph at least 500 words Can you point to times you did...
Please write a full paragraph at least 500 words Can you point to times you did or did not learn from someone else?...
1 answer
Question 6 The uniform 5.4-m pole has a mass of 235 kg and is supported as...
Question 6 The uniform 5.4-m pole has a mass of 235 kg and is supported as shown. Calculate the force P required to move the pole if the coefficient of static friction for each contact location is 0.28. Question 6 The uniform 5.4-m pole has a mass of 235 kg and is supported as shown. Calculate the ...
1 answer
Why is the coordinate plane called cartesian?
Why is the coordinate plane called cartesian?...
1 answer
Pint dunsy nch ge by e)i 04 ind E (x-): unuihy chon grven by elsewhace
pint dunsy nch ge by e)i 04 ind E (x-): unuihy chon grven by elsewhace...
1 answer
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows....
Decker Company has five products in its inventory. Information about the December 31, 2021, inventory follows. Unit Unit Selling Product Quantity Cost Price 1,200 $ 14 $20 1,000 19 800 400 see 22 17 The cost to sell for each product consists of a 10 percent sales commission Required: 1. Determine th...
1 answer
Determine the magnitude of the reaction force at pin A if the supported cylinder has a...
Determine the magnitude of the reaction force at pin A if the supported cylinder has a weight of 6 kN. d= 1.9 m; h=2.0 m Units for your answer will be kN. Assume the frame and pulley are massless. 0.3 m 0.5 m Answer: 2.53 X (10.5)...
2 answers
Find the ordered pair that represents the vector from A(-4.3,-0.9) to B(-2.8,0.2)
Find the ordered pair that represents the vector from A(-4.3,-0.9) to B(-2.8,0.2)? Then find the magnitude of AB.A. (1.5,1.1); 3.46B. (-7.1, -0.7); 7.13C. (1.5, 1.1); 1.86D.(-7.1, -1.1); 7.18I got C, is this right?...
1 answer
8 C. Worthy Ships initially issued 300,000 shares of $1 par stock for $1,500,000 in 2018....
8 C. Worthy Ships initially issued 300,000 shares of $1 par stock for $1,500,000 in 2018. In 2020, the company repurchased 30,000 shares for $300,000. In 2021, 15,000 of the repurchased shares were resold for $240,000. In its balance sheet dated December 31, 2021, C. Worthy's treasury stock acco...
1 answer
Atmospheric air enters a heating section of a duct at 1 atm, 10 °C (dry bulb),...
Atmospheric air enters a heating section of a duct at 1 atm, 10 °C (dry bulb), 40% relative humidity and a mass flow rate of 1.1 kg/s. An electrical resistance provides 4 kW of energy to the air. If the humidity ratio stays constant during the process, determine the exit temperature (dry bulb) a...
1 answer
Gas in a closed system problem 1.28
a closed system consisting of 2 lb. of a gas undergoes aprocess during which the relation between pressure and volume isPV^n=constant.the process beginswith P1=20lbf/in^2,V1=10ft^3 and ends with P2=100lbf/in^2, V2=2.9ft^3.determine...a) the value of nb) the specific volume @ state 1 and 2 each in ft...
1 answer
What is the pH at the equivalence point in the titration of a 28.7 ml sample...
What is the pH at the equivalence point in the titration of a 28.7 ml sample of a 0.314 M aqueous hydrofluoric acid solution with a 0.342 M aqueous barium hydroxide solution...
1 answer
1. 2. Problem 19-04 The accounting records of Flounder Inc. show the following data for 2020...
1. 2. Problem 19-04 The accounting records of Flounder Inc. show the following data for 2020 (its first year of operations). Life insurance expense on officers was $9,900. Equipment was acquired in early January for $288,000. Straight-line depreciation over a 5-year life is used, with no salvage val...
1 answer
What is the approximate dollar cost of the tuition and other fees associated with the economics...
What is the approximate dollar cost of the tuition and other fees associated with the economics course you are taking? Does this dollar cost fully reflect the opportunity cost to you of taking the course?...
1 answer
1.39 Identify the following as either equity or debt fi- nancing: bonds, stock sales, retained earnings,...
1.39 Identify the following as either equity or debt fi- nancing: bonds, stock sales, retained earnings, venture capital, short-term loan, capital advance from friend, cash on hand, credit card, home eq- uity loan....
1 answer
51 measured data points have a sample mean of 56.04 and a standard deviation of 3.4....
51 measured data points have a sample mean of 56.04 and a standard deviation of 3.4. Estimate the range of values for which you would expect 95% of all future measurements to fall (or for a single future measurement to fall within 95% probability). Find a, where the data is expected to fall ±...
1 answer
The alcohol could easily be converted to a tosylate, a good leaving group, and a conventional...
The alcohol could easily be converted to a tosylate, a good leaving group, and a conventional substitution reaction could have been performed instead of the nucleophilic aromatic substitution (NAS) reaction. Why was the NAS reaction the preferred method? (Hint : Look up the nucleophiles of both reac...