Question

Using the Partial Financials given below, calculate the Standard COGS %. Multiply the Standard COGS %...

Using the Partial Financials given below, calculate the Standard COGS %. Multiply the Standard COGS % by the total actual costs to determine expected sales. Compare expected sales to actual sales.

JUNE JULY AUGUST
SALES 24812.25 28516 28232.75
ACTUAL COGS
ICE CREAM 5247.79 6025.43 5505.38
TOPPINGS 1315.05 1511.35 1594.57
CONES 1463.92 1553.82 1665.73
PAPER GOODS 570.58 574.91 592.89
Total Actual Costs 8597.34 9665.51 9358.57
GROSS MARGIN 16214.91 18850.49 18874.18
GP % 65.35% 66.10% 66.85%
SANDARD COGS
ICE CREAM 4878.36 5808.18 5263.78
TOPPINGS 1103.68 1115.52 1198.66
CONES 1134.4 1242.5 1228.66
PAPER GOODS 434.72 477.07 471.33
Total Standard Costs 7551.16 8643.27 8162.43
Gross Margin 17261.09 19872.73 20070.32
GP % 69.57% 69.69% 71.09%

Homework Answers

Answer #1

Standard COGS % = Standard COGS / Sales

June = $7551.16 / 24812.25 = 30.43%
Total Actual Costs = $8597.34
Expected Sales = $8597.34 / 30.43% = $28252.84
Actual Sales = $24812.25
Variance = ($3440.59)

July = $8643.27 / 28516 = 30.31%
Total Actual Costs = $9665.51
Expected Sales = $9665.51 / 30.31% = $31888.85
Actual Sales = $28516
Variance = ($3372.85)

August = $8162.43 / 28232.75 = 28.91%
Total Actual Costs = $9358.57
Expected Sales = $9358.57 / 28.91% = $32371.39
Actual Sales = $28232.75
Variance = ($4138.64)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Practice Ch 7 Foundational 15 [The following information applies to the questions displayed below.] Morganton Company...
Practice Ch 7 Foundational 15 [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget for its first four months of operations: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,700, 18,000, 20,000, and 21,000 units, respectively. All sales are on credit. b. Forty percent of credit sales are collected in the month...
1) A budget prepared at a single volume of activity is referred to as a: A)...
1) A budget prepared at a single volume of activity is referred to as a: A) Strategic budget. B) Standard budget. C) Static budget. D) Flexible budget. Answer:  ___________ 2) Select the incorrect statement regarding flexible budgets. A) Flexible budgets often show the estimated revenues and costs at multiple volume levels. B) A flexible budget is used to compare actual to budgeted amounts. C) A flexible budget is also known as a master budget. D) Standard prices and costs are used...
[The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that...
[The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending raw materials inventory should be 30 percent of next month’s production. Expected...
A division in XYZ Co. had the following financial data for 2019: sales $500,000, average operating...
A division in XYZ Co. had the following financial data for 2019: sales $500,000, average operating assets $200,000, margin (or profit margin) 4%, minimum required rate of return 8%. What was the return on investment for the division? A. 10%. B. 20%. C. 16%. D. 12%. Patricia’s housekeeping company has the following data projected for June. Beginning cash balance $24,500 Cash collections from customers 36,200 Cash disbursements 54,300 Patricia wants to maintain a cash balance of $10,000 or more. Any...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight-...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight- ounce bottles of hand and body lotion called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case. The January direct materials, direct labor, and factory overhead costs are as follows: DIRECT MATERIALS Cost Behavior Units per Case Cost per Unit Cost per Case Cream base Variable 100 ozs. $0.02 $...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight-...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight- ounce bottles of hand and body lotion called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case. The January direct materials, direct labor, and factory overhead costs are as follows: DIRECT MATERIALS Cost Behavior Units per Case Cost per Unit Cost per Case Cream base Variable 100 ozs. $0.02 $...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight-...
Genuine Spice Inc. began operations on January 1 of the current year. The company produces eight- ounce bottles of hand and body lotion called Eternal Beauty. The lotion is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case. The January direct materials, direct labor, and factory overhead costs are as follows: DIRECT MATERIALS Cost Behavior Units per Case Cost per Unit Cost per Case Cream base Variable 100 oz. $0.02 $...
Please calculate the current ratio and acid test from the balance sheet and income statement below....
Please calculate the current ratio and acid test from the balance sheet and income statement below. I am not sure what I am doing wrong here to calculate the current ratio and acid test ratio for 2017 and 2018. Do I need to include the current notes payable due this within the year as a current liability ? Marin Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common...
Gargantuan Industries is a multiproduct company with several manufacturing plants. The Boise Plant manufactures and distributes...
Gargantuan Industries is a multiproduct company with several manufacturing plants. The Boise Plant manufactures and distributes two household cleaning and polishing compounds, standard and commercial, under the Super Clean label. The forecasted operating results for the first six months of the current year, when 100,000 cases of each compound are expected to be manufactured and sold, are presented in the following statement. SUPER CLEAN COMPOUNDS—BOISE PLANT Forecasted Results of Operations For the Six-Month Period Ending June 30 (in thousands) Sales...
You are the assistant controller for Gnomes Incorporated. After the abysmal failure of their original business...
You are the assistant controller for Gnomes Incorporated. After the abysmal failure of their original business plan, Gnomes has found success by selling various styles of terracotta garden gnomes. You have been asked to prepare the master budget for the quarter ended June 30th, 2016. You have assembled the following information: The garden gnomes sell for $40 each. Recent and forecasted sales (in units) are as follows: January (actual)                                                      800 February (actual)                                                    900 March (actual)                                                     1,800 April                                                                    2,800 May                                                                    3,500...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • A two-component mixture containing 70% of Mineral A and 30% of Mineral B is floated in...
    asked 5 minutes ago
  • A researcher wanted to investigate an effect of listening to hip-hop music on reading comprehension. She...
    asked 6 minutes ago
  • In the determination of the alkalinity of a wastewater sample, we have the following data Final...
    asked 6 minutes ago
  • A hungry 161 kg lion running northward at 82.7 km/hr attacks and holds onto a 39.2...
    asked 16 minutes ago
  • Part A For the reaction 2Co3+(aq)+2Cl−(aq)→2Co2+(aq)+Cl2(g). E∘=0.483 V what is the cell potential at 25 ∘C...
    asked 31 minutes ago
  • 1249) The solution of some second order linear DEQ is exp(-9x)[9sin(1x)+ 3cos(1x)] which can also be...
    asked 31 minutes ago
  • Create a stadium class. The class header file content (.h file) can go in this question,...
    asked 31 minutes ago
  • Describe research designs used in the area of psychopathology and identify at least two ethical concerns...
    asked 44 minutes ago
  • Dry ice is solid carbon dioxide. Instead of melting, solid carbon dioxide sublimes according to the...
    asked 53 minutes ago
  • The patient recovery time from a particular surgical procedure is normally distributed with a mean of...
    asked 1 hour ago
  • In a certain school district, it was observed that 26% of the students in the element...
    asked 1 hour ago
  • Solve 8cos2(x)+2cos(x)−3=08cos2(x)+2cos(x)-3=0 for all solutions 0≤x<2π0≤x<2π and Solve 6sin2(w)−cos(w)−5=06sin2(w)-cos(w)-5=0 for all solutions 0≤w<2π0≤w<2π
    asked 1 hour ago