Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.55 per pound. 15,900 units used 35,900 pounds, which were purchased at $3.70 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Direct materials price variance $ fill in the blank 2 b. Direct materials quantity variance $ fill in the blank 4 c. Direct materials cost variance $

Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.55 per pound. 15,900 units used 35,900 pounds, which were purchased at $3.70 per pound. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Direct materials price variance $ fill in the blank 2 b. Direct materials quantity variance $ fill in the blank 4 c. Direct materials cost variance $

Name: eBook Show Me How Office 365Question Content AreaDirect materials vari
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: eBook Show Me How Office 365Question Content AreaDirect materials variancesBellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.55 per pound. 15,900 units used 35,900 pounds, which were purchased

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 2R

See similar textbooks

Question Content Area

Direct materials variances

Bellingham Company produces a product that requires 2.3 standard pounds per unit. The standard price is $3.55 per pound. 15,900 units used 35,900 pounds, which were purchased at $3.70 per pound.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance? Round your answers to the nearest dollar. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.

a. Direct materials price variance	$ fill in the blank 2
b. Direct materials quantity variance	$ fill in the blank 4
c. Direct materials cost variance	$

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.
Part 1: Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab):• Calculate the contribution margin (CM) for each of the three products sold at the cookie business.• Calculate the weighted average CM.• Calculate the breakeven point.Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, etc.
engageNOWv2 | Online teach x + n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false O SOFTWARE UPDATE 34m macOS Big Sur 11.3.1 is available and will be instal later tonight. еBook E Print Item Single plantwide factory overhead rate Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and oboes. The budgeted factory overhead cost is $88,320. Overhead is allocated to the three products on the basis of direct labor hours. The products have the following budgeted production volume and direct labor hours per unit: Budgeted Production Direct Labor Hours Per Volume Unit Flutes 2,600 units 0.4 Clarinets 600 1.6 Oboes 1,400 1.2 If required, round all per unit answers to the nearest cent. a. Determine the single plantwide overhead rate. X per direct labor hour b. Use the overhead rate in (a) to determine the amount of total and per-unit overhead allocated to each of the three products. Total Per Unit Factory Overhead Cost Factory…
Home File Paste AutoSave Off H X Insert Draw Design Layout References Mailings Review View Help Editing A = rM Font Paragraph Styles Editing Sensitivity Dictate Editor Add-ins Read on reMarkable Clipboard S Styles Voice Sensitivity Editor Add-ins reMarkable EX.22-04 ALGO Flexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet Supervisor salaries Depreciation Direct labor rate 20 minutes $114,000 per month $31,000 per month $24 per hour Prepare a flexible budget for 13,000, 16,000, and 20,000 filing cabinets for the month of August in the Assembly Department. Assuming that inventories are not significant. Enter all amounts as positive numbers. CABINAIRE INC-ASSEMBLY DEPARTMENT Flexible Production Budget For the Month Ending August 31…
onedrive.live.com/?cid%3D95827CFFCF17 ايسر سبين 3، را Join Meeting - Zoom Sign In Zoom Micr... - Jg Juzeui Goo صدارات Exercise 1. Classify the below cost on their behavior (Fixed Costs and Variable Costs) (a) Rent of Factory Building, (b) Managerial Salaries, (c)Direct wages, (d) Direct Materials, (e) Building Insurance, (f) Commission of salesman, (g)Municipal taxes, (h) Power, (1) Normal Spoilage, G) Small tools Exercise 2 The Information bellow has been taken from production department of XYZ Company for December is as follows: Total Costs Variable Cost Fixed Cost Material used in Production OMR 200000 200000 Labour used in Production 150000 100000 50000 (Assembly and supervisor) Production Facilities cost ( 50000 40000 10000 rent general, utilities.)
p.mheducation.com/ext/map/index.html?_con=con&external_browser%3D0&launchUrl=https%253A%252F%252Flms.mhe D and P Indeed 6 Monster Jobs w Degree Programs O L02 A Hearn: Student Da.. 6 Consumer Center ework: Assignment 1 i Saved Perez Company reported the following operating results for two consecutive years: Required Compute each income statement component for each of the two years as a percentage of sales due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be e PEREZ COMPANY Vertical Analysis of Income Statements Percentage of Sales Percentage of Sales Year 4 Year 3 Sales 1,077,500 00S'000'L Cost of goods sold 550,275 000 Z09 Gross margin on sales 450,225 475,500 Operating expenses 130,500 149,800 319.725 325,700 Income before taxes 79.700 81,800 Income taxes 240.025 243.900 % Net income
Excel File Edit View Insert Format Tools Data .. AutoSaveB2-C- Home Insert Draw Page Layout - n Paste H16 X 12 13 Calibri (Body) B I U . 14 14 15 16 17 18 19 20 21 33 Ready HY B A B 1 Formulas: Multiply, Add, Divide; Cell Referencing 2 12 Direct labor rate per hour Markup charged on jobs Enter Answer + Accessibility: Investigate Formulas LEOO tab *** A A & A ✓ Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. x ✓ fx Budgeted MOH costs at start of year Budgeted direct labor hours at start of year Estimated hours for new client's job esc BE8.12-Using Excel to Determine Job Cost and Bid Price for a Service 4 Company 5 PROBLEM 6 Jace and Associates provides professional consulting services to a variety of 7 clientele in an effort to help them improve the operating effectiveness and 8 profitability of their businesses. The company's accountant established 9 budgeted direct labor hours as its allocation base. The company is 10…
File Home Insert Page Layout Formulas Data Review View Help Calibri 11 -A A 22 Wrap Text General Paste BIU- O. A- S- % 9 8 8 Co E Merge & Center Fom Clipboard Font Alignment Number i UPDATES AVAILABLE Updates for Office ate ready to be installed, but first we need to close some apps Update now M3 15 16 Requirement 8: Complete the Income Statement. 17 18 Cedar River Trikes 19 Income Statement Month Ended June 30, 2018 20 21 22 (23 Sales Revenue 450,000 Cost of Goods Sold 25 24 249,300 Gross Profit 200, 700 5,400 206, 100 26 Selling and Administrative Expense 27 Net Income 28 29 30 31 HINTS All values should be entered as positive values where appropriate. Use minus sign to enter valuea 32 being deducted. 33 Cell | Hint: (Use the numeric values from other tabs where appropriate. Do not use an equal sign () when instructions ENTERANSWERS1 ENTERANSWERS2 ENTERANSWERS3 ENTERANSWERS4 ENTERANSIVER Ready O Type here to search
ENOWV2 | Online teach x SOFTWARE UPDATE KeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false macOS Big Sur 11.3.1 is available and will be later tonight. eBook Show Me How E Print Item Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are $8.90 per quest check-in, $19.00 per room cleaning, and $2.00 per served meal (not including food). Janelle Washington visited the hotel for a 5-night stay. Janelle had 6 meals in the hotel during the visit. Determine the total activity-based cost for Washington's visit during the month. Round your answer to the nearest cent. Feedback Check My Work Calculate: Number of activities x Activity rate = Cost of activity Sum all activity costs to determine the total. Check My Work Previous Next Email…
eBook Show Me How Print Item Question Content Area Syntech makes digital cameras for drones. Their basic digital camera uses $80 in variable costs and requires $1,500 per month in fixed costs. Syntech sells 100 cameras per month. If they process the camera further to enhance its functionality, it will require an additional $50 per unit of variable costs, plus an increase in fixed costs of $1,000 per month. The current price of the camera is $170. The marketing manager is positive that they can sell more and charge a higher price for the improved version. At what price level would the upgraded camera begin to improve operational earnings? Price to be charged $???
File Edit View Go Tools Window Help A ASSIGNMENT NO.1 BUSS 104.pdf (page 4 of 4) Q Search Question 5: The Information below is taken from production department of Salalah Company for April: The number of units produced is 10000. All amounts are in OMR. Total Costs Variable Cost Fixed Cost 500000 Direct material cost Total labor cost 400000 100000 Manufacturing Overhead 90000 30000 Calculate: A. Find the missing information in the above table. Some values may not be applicable, explain. B. Calculate cost per unit C. Describe the production costs in the equation form Y f+ vX. D. Assume Salalah intends to produce 10000 units next month. Calculate total production costs for the month
O Topic: Week 6: Discu ssion IIl x + a ezto.mheducation.com/ext/map/index.html?_con=con&external_browser-D0& launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F# z- Chapter 6 A Saved Denton Company manufactures and sells a single product. Cost data for the product are given: Variable costs per unit: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Total variable cost per unit Skipped 2$ 3 12 2 3 $ 20 Fixed costs per month: Fixed manufacturing overhead Fixed selling and administrative $ 96, 000 166, 000 $ 262, 000 Total fixed cost per month The product sells for $45 per unit. Production and sales data for July and August, the first two months of operations, follow: Units Produced 24, 000 24, 000 Units Sold July August 20, 000 28, 000 The company's Accounting Department has prepared the following absorption costing income statements for July and August: Sales Cost of goods sold Gross margin Selling and administrative expenses…