Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations. Calculate...

Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations.

Calculate the material variances.
Calculate the labor variances.

Complete your calculations by filling the in highlighted cells. Discuss your observations about the variances and ways to plan to improve any of the variances.

Cookie Business


Actual Cost of Direct Materials	$ 225,000
Standard Cost of Direct Materials	$ 224,800
Actual Materials Used	30
Standard Materials Used	31

Actual Direct Labor Rate	$ 15.50
Standard Labor Rate	$ 15.00
Actual Hours Worked	45
Standard Hours Worked	40

	Amount	Favorable/ Unfavorable
Calculate Materials Variances:
Materials Price Variance
Materials Quantity Variance

Calculate Labor Variances:
Labor Rate Variance
Labor Efficiency Variance

Expert Solution

ekkarill92 answered 2 years ago

Based on the data presented in the Spreadsheet below (Cash Budget tab), calculate the cash receipts...

Based on the data presented in the Spreadsheet below (Cash Budget tab), calculate the cash receipts for the first quarter of this year. Complete your calculations by filling in the highlighted cells. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses. Cookie Business The budgeted credit sales are as follows: December last year $ 250,000 January $ 125,000 February $ 300,000 March $ 90,000 Collection: Month of the sale 80% Month...

Using the information on the Data tab of the spreadsheet , complete the cost of goods...

Using the information on the Data tab of the spreadsheet , complete the cost of goods manufactured for January. Show calculations for all items/questions Below is manufacturing data from Webster Company for January, 2020. Beginning raw materials inventory $ 321,300 Raw materials purchased $ 845,150 Ending raw materials inventory $ 275,475 Direct labor costs $ 104,590 Indirect materials $ 47,560 Indirect labor $ 29,876 Factory utilities and maintenance $ 148,890 Factory depreciation $ 19,876 Other factory related overhead $ 7,890...

Following the instructions on the Data tab, complete the spreadsheet for your Chief Financial Officer. Estimates...

Following the instructions on the Data tab, complete the spreadsheet for your Chief Financial Officer. Estimates at the beginning of the year Assembly Production Total Manufacturing Overhead Costs $ 480,000 $ 528,000 $ 108,000 Direct Labor-hours 12,000 7,200 19,200 Machine hours 4,800 24,000 28,800 Job 142 Direct labor-hours 25 17 42 Machine hours 17 20 37 1. Calculate the amount of manufacturing overhead applied to Job 142. Converse uses a plantwide predetermined overhead rate...

Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...

Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer. A local pastry shop is planning their next morning’s production. The shop has three main items that they sell: cakes, cupcakes, and cannolis. All of these are made in-house with the shop’s own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flower, 15 g of...

Based on the following information, complete the required calculations listed below: Factory utilities: $ 15,000 Direct...

Based on the following information, complete the required calculations listed below: Factory utilities: $ 15,000 Direct labor: $ 75,000 Depreciation on factory equipment: $ 13,000 Sales salaries: $ 45,000 Depreciation on delivery trucks: $ 5,000 Property taxes on factory building: $ 4,000 Indirect factory labor: $ 50,000 Repairs to office equipment: $ 2,000 Indirect materials: $ 80,000 Sales revenue: $ 350,000 Direct materials used: $ 140,000 Advertising: $ 16,000 Factory manager's salary: $ 8,000 Office supplies used: $ 3,000 Assume...

Find the inflation rate based in the information presented in the table below. For you calculations...

Find the inflation rate based in the information presented in the table below. For you calculations assume a fix consumption basket consisting of 3 footballs and 4 basketballs, and year 1 as the base year. Year Price of Footballs Price of Basketballs Year 1 $10 $12 Year 2 12 15 Year 3 14 18

In the Ratios tab of the FSAR Excel Spreadsheet, complete the Short-Term Debt Paying Ratios, Asset...

In the Ratios tab of the FSAR Excel Spreadsheet, complete the Short-Term Debt Paying Ratios, Asset Utilization or Turnover Ratios, and the Long-Term Solvency or Financial Leverage sections. Calculate of the short-term debt paying ratios. Calculate the long-term debt paying or financial leverage ratios. Calculate the five significant asset utilization or turnover ratios. Ratios Comments Liquidity Ratios Company Competitor Industry Short-Term Debt Paying Ratios Year Year Year Working Capital Current Ratio Acid Test Ratio Cash Ratio Long-Term Solvency or Financial...

Based on your calculations of the spot rates below, calculate: a. The forward rate for a...

Based on your calculations of the spot rates below, calculate: a. The forward rate for a one-year zero issued one year from today, f(1,1) b. The forward rate for a one-year zero issued 2 years from today, f(2,1) c. The forward rate for a two-year zero issued two years from today, f(2,2) Maturity Par Rate Spot Rate 1 2.00% 2.00% 2 2.57% 2.5774% 3 3.11% 3.1331% 4 3.88% 3.9490% Please show work!

Complete the steps below using cell references to given data or previous calculations. In some cases,...

Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference...

Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas...

Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges. You can start this by taking the finance charge in month 1. With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year. The APR is 24.99% and the minimum payment...

Question