1 answer

Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory...

Question:

Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Walton’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $83,000.

Required

  1. Complete the inventory purchases budget by filling in the missing amounts.

  2. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.

  3. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

Complete the inventory purchases budget by filling in the missing amounts.

Inventory Purchases Budget
January February March
Budgeted cost of goods sold $53,000 $57,000 $63,000
Plus: Desired ending inventory 8,550
Inventory needed 61,550
Less: Beginning inventory 7,950
Required purchases (on account) $53,600

Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

b. Cost of goods sold
c. Ending inventory

Answers

Inventory purchase budget :

Inventory Purchases Budget
January February March
Budgeted cost of goods sold $53,000 $57,000 $63,000
Plus: Desired ending inventory 8,550 9450 12450
Inventory needed 61,550 66450 75450
Less: Beginning inventory 7,950 8550 9450
Required purchases (on account) $53,600 $57900 $66000

Note 1: calculation of ending inventory for February month -

Ending inventory = cost of goods sold of next month ×15%

= $63000×15%

= $9450

Note 2: calculation of ending inventory of March month -

= $83000 × 15%

= $12450

Note 3: ending inventory of one month becomes the beginning inventory of next month. Therefore, ending inventory of February and March will be $8550 and $9450 respectively.

Amount of cost of goods sold the company will report on its first quarter pro forma income statement = sum of cost of goods sold of Jan, Feb and march.

= $53000+$57000+$63000

= $173000

Amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter = ending inventory of March month.

= $12450 (as per note 2).

.

Similar Solved Questions

1 answer
On August 1, 2021, Trico Technologies, an aeronautic electronics company, borrows $19.4 million cash to expand...
On August 1, 2021, Trico Technologies, an aeronautic electronics company, borrows $19.4 million cash to expand operations. The loan is made by FirstBanc Corp. under a short-term line of credit arrangement. Trico signs a six-month, 9% promissory note. Interest is payable at maturity. FirstBanc Corp&#...
1 answer
Is #y = x^2# a direct variation equation?
Is #y = x^2# a direct variation equation?...
1 answer
The dependent variable is the position (y-axis) and the independent variable is the time (x-axis). This...
The dependent variable is the position (y-axis) and the independent variable is the time (x-axis). This is the measured position of a rock as it falls from the top of a very high cliff and obeys the equations y = 1/2gt2. Make sure you label the plot properly. Right click on a data point in the graph...
1 answer
How do you simplify #(x + 3)/(x^2 + 5x + 6)#?
How do you simplify #(x + 3)/(x^2 + 5x + 6)#?...
1 answer
Cot(t) Simplify to a single trig function with no csc(t) – sin(t) fractions.
cot(t) Simplify to a single trig function with no csc(t) – sin(t) fractions....
1 answer
How do you prove #(a o+ b) o+ (~ a & ~ b) = 1# ?
How do you prove #(a o+ b) o+ (~ a & ~ b) = 1# ?...
1 answer
Question 6. Please show your working for all questions. (a) If a radioactive nuclide decays for...
Question 6. Please show your working for all questions. (a) If a radioactive nuclide decays for an interval of time equal to 4 times its half-life, what fraction of the original activity remains ? (b) A researcher is doing an experiment with a cell culture to image the DNA. To do so, the researcher ...
1 answer
Just help with this question please? Lab 8: Studying Chemical Equilibria and Applying Le Chatelier's Principle...
Just help with this question please? Lab 8: Studying Chemical Equilibria and Applying Le Chatelier's Principle Using Microscale Techniques 4. A student is studying the equilibrium described by Equation 19 heat + Coso, . 7 H2O(s, pink) + 7SOCIeO-Coso,(s, blue) + 7S02(g) + 14HC?(g) (Eq.19) Usi...
1 answer
Microprocessor 4. (3 marks) Complete the LEAS line of code in the following program code snippet:...
microprocessor 4. (3 marks) Complete the LEAS line of code in the following program code snippet: ...some code PSHA PSHB PSHX JSR DoJob PULX LEAS ??,?? ..rest of the code...
1 answer
Find the standardized test statistic to test the claim that μ1 < μ2. Two samples are...
Find the standardized test statistic to test the claim that μ1 < μ2. Two samples are random, independent, and come from populations that are normally distributed. The sample statistics are given below. Assume that σ 2 /1 = σ 2 /2 . n1 = 15 n2 = 13 x1 = 27.88 x2 = 30.43 s1 = 2.9 ...
1 answer
When calcium carbonate is added to hydrochloric acid, calcium chloride, carbon dioxide, and water are produced....
When calcium carbonate is added to hydrochloric acid, calcium chloride, carbon dioxide, and water are produced. CaCO,(s) + 2 HCl(aq) — CaCl, (aq) + H2O(1) + CO2(g) How many grams of calcium chloride will be produced when 25.0 g of calcium carbonate is combined with 10.0 g of hydrochloric acid?...
1 answer
Please write nearly and clearly Density of states 1. Calculate density of states of free electron...
please write nearly and clearly Density of states 1. Calculate density of states of free electron and free holes of an energy of 1 eV in Si, Ge and GaAs. 2. Calculate/Estimate concentration of electrons and holes in Si, Ge and GaAs at temperatures 100, 300 and 1000K....
1 answer
How could IR spectroscopy distinguish between 1-hexyne, 2-hexyne, and 3-hexyne?
How could IR spectroscopy distinguish between 1-hexyne, 2-hexyne, and 3-hexyne?...
1 answer
1. List all the controllable risk factors for coronary heart disease (i.e. smoking) AND explain why...
1. List all the controllable risk factors for coronary heart disease (i.e. smoking) AND explain why they are so dangerous to our hearts. 2.List the uncontrollable risk factors for Coronary Heart Disease/Coronary Artery Disease (i.e. age). 3. Define the following items: Angina Pectoris Ischemia Ather...
1 answer
Complete the sentences about evolutionary change using the terms on the left. communicate A melti...
Complete the sentences about evolutionary change using the terms on the left. communicate A melting glacier creates a river that separatesa squirrels. Resources, predators, and other slightly between the two sides of the river more less Since the two populations of squirrels cannot adaptations favor...
1 answer
Consider the three stocks in the following table. Pt represents price at time t, and Qt...
Consider the three stocks in the following table. Pt represents price at time t, and Qt represents shares outstanding at timet. Stock C splits two-for-one in the last perioc p. 90 50 200 45 200 45 200 95 100 95 100 100 200 1020055 Calculate the first-period rates of return on the following indexes o...
1 answer
According to a recent study, 44% of physicians surveyed said they communicate with patients through e-mail....
According to a recent study, 44% of physicians surveyed said they communicate with patients through e-mail. A random sample of 120 physicians was selected. What is the probability that 50 or more from this sample e-mail their patients? A. 0.4168 B. 0.4830 C. 0.6042 D. 0.6950...
1 answer
Wwwcomerc PP 4. What is categorical aid? What are the two key features that a category...
wwwcomerc PP 4. What is categorical aid? What are the two key features that a category must feature is categorical aid is to be most effective? What are the major categories of people identified for aid in the U.S....
1 answer
Please answer all step by step as soon as possible. Two long wires are oriented so...
Please answer all step by step as soon as possible. Two long wires are oriented so that they are perpendicular to each other. At their closest, they are 20.0 cm apart. What is the magnitude of the magnetic field at a point P between them if the top one carries a current of 18.0 A to the left and the...