ATC 8-6 Spreadsheet Assignment Using Excel Irvine Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price $48.00 Materials cost 12.00 Labor cost 6.00 Overhead cost 8.40 Selling, general, and administrative costs 9.60 Expected fixed costs Manufacturing overhead $180,000 Selling, general, and administrative 72,000 Irvine planned to make and sell 30,000 copies of the book. Page Required Construct a spreadsheet like the one shown in Exhibit 8.1 to illustrate a static budget and a flexible budget for production volumes of 28,000, 29,000, 30,000, 31,000, and 32,000.
Q: Solomon Fruit Drink Company planned to make 200,000 containers of apple juice. It expected to use…
A: * As per Bartleby policy, in case multiple questions are asked then answer first three only. 1.…
Q: Balance Est. Percentage Uncollectible Age Interval Not due $63,000 2% 1-30 days past due 7,100 5%…
A: Lets understand the basics. Entity generally calculates the estimated uncollectible amount to make a…
Q: QUESTION 1 *COGS $390,000 •GM 60% %3D •Store size: 20 ft x 25 ft. •2,500 transactions •5,000 units…
A: The question is related to Marginal Costing and Cost Volume Profit Analysis.
Q: To measure the financial viability of a proposed business, which is the more powerful measure-…
A: Ratio analysis involves evaluation of various operational aspects of the business such as liquidity,…
Q: Why is preparation of the government-wide statements considered to be "challenging"?
A: Government accounting seems to be a systematic technique for gathering, categorizing, documenting,…
Q: Marin Leasing Company signs an agreement on January 1, 2020, to lease equipment to Cole Company. The…
A: Note:- Since the lessor's desired rate of return on its investment is missing in the question,…
Q: Question 1 UMU has demand for 1400 water pumps each year. The cost of a water pump to LUMU is $400.…
A: Economic order quantity is the optimal quantity to be ordered to minimize the overall cost.
Q: On Jan 5th, 2021, Issue 20,000 common shares at $11 each (100,000 authorized & $2 par value) to Jack…
A:
Q: On June 1, 2021, Demer Consulting provides services to a customer for $150,000. To pay for the…
A: The journal entries are prepared to record the day to day transactions of the business during the…
Q: Preparing Common-Size Income Statements by Using BasePeriod Horizontal AnalysisRefer to the…
A: A common size income statement would be one wherein each line item is stated as a % of the revenue…
Q: a-1. Determine the unadjusted rate of return and (use ave places. (i.e., 0.2345 should be entered as…
A: IRR is a tool that is used to calculate the return over the project cash flow or its investment. If…
Q: Using the following information: a. The bank statement balance is $3,351. b. The cash account…
A: Bank reconciliation is the method of validating all cash account balances in an entity's accounting…
Q: We-Sell Realty was organized as a corporation on August 1, 20Y7, by the issuance of common stock of…
A: The errors are listed as,
Q: A 1000 par value 10-year bond with 6.0% semiannual coupons was convertible semiannually. bought to…
A: It is the amount liable to the bondholders by the issuer of bonds. These bonds payable will be…
Q: You must evaluate a proposal to buy a new milling machine. The purchase price of the milling…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Macinski Leasing Company Leases a new machine to Sharrer Corporation. The machine has a cost of…
A: Solution Working- Annual repayment amount = Fair value of machine / Present value of 3 years. =…
Q: Management of Great Springs Bottled Water Company has asked you, the controller, to develop a…
A: In this question, we will make Income statement of Great Springs Bottled Water and find out the…
Q: Using the following information: a. The bank statement balance is $4,690. b. The cash account…
A: Bank reconciliation reconcile the bank balance with book balance as per financial records.
Q: For the past year, Kayla, Incorporated, has sales of $46,967, interest expense of $4,088, cost of…
A: Operating Cash Flow = Net Income + Non-Cash Expense (Depreciation) As per US GAAP, Interest Paid is…
Q: Determine the monthly principal and interest payment for a 20-year mortgage when the amount fr the…
A: In this question we have to calculate the monthly interest and principal payment. Compound interest:…
Q: Prepare journal entries for each of the following transactions entered into by the City of Loveland.…
A: "Since you have posted a question with multiple subparts, we will solve the first three subparts for…
Q: Caribbean. prs a define
A: Notes : According to Generally Accepted Accounting Principles (GAAP), net pension spending in the…
Q: Reece Financial Services Co., which specializes in appliance repair services, is owned and oper-…
A: Adjusted trial balance An adjusted trial balance is a list of the ending balances in all accounts…
Q: Which of the following is a characteristic of managerial accounting?a. There is an internal focus.b.…
A: Managerial accounting (often referred to as cost accounting or management accounting) seems to be a…
Q: SydMel Ltd commences operations on 1 July 2020. One year later, on 30 June 2021, the entity prepares…
A: The calculation of the deferred tax while taking consider the accounting profit with the adjustment…
Q: Question 15 Companies can set transfer prices to shift profits between the buyer and seller…
A: Transfer Price is the price charged by the transferor department to transferee department. It is…
Q: The following information is also available: Beginning balance of Accounts Receivable P 500,000 Net…
A: >Bad Debt Expense is recorded using two methods: #1: Direct write off method: Expense is…
Q: A home theater system is on sale for $777. If the list price is $925, find the percent of markdown.…
A: Markdown means the reduction in the price of the sale value of goods. Formula: Markdown amount =…
Q: April Issued 5,000 share of Common Stock, $2 par for $17 per share. Record the journal entry.
A: Journal is the book of original entry in which all the financial transactions of the business are…
Q: Quick BQtio lor all Years Yeath As Reported Annual Balance Sheet Report Date Scale 2019 2017…
A: Formula: Quick ratio = Quick Assets / current liabilities.
Q: Rostand Inc. operates a delivery service for over 70 restaurants. The corporation has a fleetof…
A: Variance refers to the difference of budgeted and actual figures relating to revenue or expense…
Q: Primara Corporation has a standard costing system in which it applies overhead to products on the…
A: Predetermined overhead rate(fixed portion)= Budgeted fixed overhead cost/Budgeted direct labor hours…
Q: How is total cost of goods sold and the total amount billed to customers calculated?
A: A job cost sheet is a sheet which is used to record the manufacturing costs .
Q: Refer to the information for Cuneo Company above.Required:1. Prepare a common-size income statement…
A: A common-size income statement seems to be one where every line item is stated as a percentage of a…
Q: can anyone one help me to prepare general ledger for following
A: General Ledger The purpose of preparing the general ledger to know the ending balance of each…
Q: Assets Liabilities and Equity Cash Accounts receivables 34,000 Inventory Prepaid Insurance Capital…
A: Assets=Liabilities+Shareholders' Equity
Q: Which of the following is not a characteristic of a lean accounting system? Multiple Cholce Costs in…
A: lean accounting is the collection of principal and the process that provides the numerical feedback…
Q: Case Scenario1 - Hien Hien is in business selling high quality glassware to retailers. Her…
A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…
Q: What other sources provide resources for capital projects funds?
A: A capital project seems to be a long-term, capital-intensive investing project with the goal of…
Q: The management of Springer plc is considering next year’s production and purchase budget. One of…
A: GIVEN The management of Springer plc is considering next year’s production and purchase budget.…
Q: How can the predetermined factory overhead rate be used in job order cost accounting to assist…
A: Factory overheads refer to the total cost of manufacturing and operating a manufacturing process, is…
Q: An accrual income statement for 2021 reveals: a. Profit from crops and livestock produced in…
A: Income statement refers to one of the statement which states the financial position of the business…
Q: The appropriate asset value reported in the balance sheet by the lessee for an operating lease is:
A: GIVEN The appropriate asset value reported in the balance sheet by the lessee for an operating…
Q: Biases like motivated reasoning and surrogation are very prevalent in the business world. Man- agers…
A: Introduction: A balanced scorecard is a type of performance monitoring method used in businesses…
Q: Shannon's income tax rate was 25% in 2021 and previous years. During the course of the audit, the…
A: Fair value adjustment Investment balance as reported(Assumed) 250000 Error adjustment 40000…
Q: Record the journal entry.
A: Answer:
Q: Year 1 Sales $161,120 Cost of Goods Sold 105,035 SG&A 42.957 Depreciation 6,687 Operating Income…
A: Debt would be defined as the sum owing for borrowed cash. The lender accepts to lend cash to the…
Q: Prior to 23 October 2027, the share capital account of Fallout Ltd had a balance of $50,000. This…
A: The correct answer for the above mentioned question is given in the following steps for your…
Q: capital controls, which investment would you choose? What are the risks associated with this trade?
A: The United States has always been ranked among the best in the world for its competitiveness and…
Q: Which of the following is an indirect cost?a. The cost of denim in a jeans factoryb. The cost of…
A: Indirect costs would be those that cannot be linked to a specific cost object or cost source. Costs…
Step by step
Solved in 2 steps with 2 images
- Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9) Instructions This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. Based on the information above, complete the following: 1.…Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9) This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. 1. Standard product cost Item Price Quantity Total Direct materials…Table 2Activity Cost Pool Total Cost Total ActivityAssembly $ 1,114,920 57,000 machine-hoursProcessing orders $ 47,016 1,800 ordersInspection $ 107,328 1,560 inspection-hours Use Table 2 to answer this question. XYZ Corporation has provided the following data from its activity-based costing system (Table 2). The company makes 430 units of product ABA a year, requiring a total of 1,120 machine-hours, 35 orders, and 40 inspection-hours per year. The product's direct materials cost is $49.81 per unit and its direct labor cost is $12.34 per unit. The product sells for $130 per unit. According to the activity-based costing system, the product margin for product ABA is: Select one: a. $4,290.10. b. $3,815.50. c. none of the given answer. d. $4,159.50. e. $3,602.10.
- ParticularsAmountDirect materialR12Direct laborR50Variable manufacturing overheadR6.50Fixed manufacturing overhead (R81,000/2,550 units)R31.76Unit product cost for the month under absorption costingR100.26 Prepare an income statement for the month using the Marginal costing methodYPLUS Kimmel, Accounting, 7e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NEXT National Corporation needs to set a target price for its newly designed product M14-M16. The following data relate to this new product. RESOURCES OMEWORK --05 -07 -09 -11 a-b Per Unit Total Direct materials $21 -16 Direct labor $41 --01A -02A -03A Variable manufacturing overhead Fixed manufacturing overhead $14 $1,264,000 Variable selling and administrative expenses $ 4 Fixed selling and administrative expenses $ 1,106,000 Its by Study These costs are based on a budgeted volume of 79,000 units produced and sold each year. National uses cost-plus pricing methods to set its target selling price. The markup percentage on total unit cost is 40%. Compute the total variable cost per unit, otal fixed cost per unit, and total cost per unit for M14-M16. Variable cost per unit 2$ Fixed cost per unit Total cost per unit 24 MacBookAssignment CALCULATOR FULL SCREEN PRINTER VI Exercise 6-09 a1,a2, b (Part Level Submission) Moath Company reports the following for the month of June. Unit Cost Total Cost $ 1,000 Units June 1 Inventory 200 $5 12 Purchase 400 6 2,400 23 Purchase 300 2,100 30 Inventory 100 (a1) |Your answer is incorrect. Try again. Calulate Weighted Average Unit Cost. (Round answer to 2 decimal places, e.g. 15.25.) Weighted Average Unit Cost LINK TO TEXT Attempts: 1 of 15 used SAVE FOR LAT
- Product BO Product B5 Total direct labor-hours Barkes, Incorporated, manufactures and sells two products: Product BO and Product B5. Data concerning the expected production of each product and the expected total direct labor-hours (DLHS) required to produce that output appear below: Activity Cost Pools Labor-related Production orders. Order size Multiple Choice Direct Labor- Activity Measures DLHS orders MHS Expected Hours Per Production 400 500 Saved Unit 7.0 4.0 The direct labor rate is $22.10 per DLH. The direct materials cost per unit is $288.10 for Product B0 and $118.90 for Product B5. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Expected Activity Estimated Overhead Cost A Product B0 Product B5 $ 136,944 2,800 500 64,629 588,294 3,300 $789,867 Total Direct Labor- Humans and Animals Parallels प Save & Exit Submit +88Question 3 Part I Advent Corporation has implemented an Activity Based Costing System. The company wants to useABC on its two main products, V1 and V2, and three main activities as follows:ActivityCost Driver Overhead Amount Total Driver VolumeIssuing Purchase Orders # of Purchase Orders $ 150,000 50,000Reviewing Receiving Reports # of Receiving Reports $ 175,000 20,000Making Phone Calls # of Phone Calls $ 450,000 100,000During the year:Product V1 required 150 purchase orders; 150 receiving reports; and 200 phone calls.Product V2 required100 purchase orders; 400 receiving reports; and 350 phone calls. Required:a. Compute the pre-determined overhead rate for each cost pool. b. Compute the total manufacturing overhead cost for Product V1 and Product V2.keAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false E Print Item Sitka Industries uses a cost system that carries direct materials inventory at a standard cost. The controller has established these standards for one ladder (unit): Standard Standard Standard %3D Quantity Price Cost Direct materials 3 pounds $4.50 per pound $13.50 Direct labor 2.00 hours 12.00 per hour 24.00 Total cost $37.50 Sitka Industries made 3,100 ladders in July and used 9,200 pounds of material to make these units. Sitka Industries bought 15,600 pounds of material in the curr period. There was a $300 unfavorable direct materials price variance. Enter all amounts as positive numbers. A. How much in total did Sitka pay for the 15,600 pounds? Amount paid B. What is the direct materials quantity variance? Direct materials quantity variance $ C. What is the total direct materials cost variance? Total direct materials cost variance $ D. What if 9,800 pounds were used to make these…
- all Youlube Maps GE News G Translate Q Moral Choices Tes... CengageNOWv2 .. Bb Home Page- PSY... 8.5" x 14" Tri eBook Variable Costing Income Statement On July 31, the end of the first month of operations, Rhys Company prepared the following income statement, based on the absorption costing concept: Sales (96,000 units) $4,440,000 Cost of goods sold: Cost of goods manufactured $3,120,000 Less ending inventory (24,000 units) 624,000 Cost of goods sold 2,496,000 Gross profit $1,944,000 Selling and administrative expenses 288,000 Income from operations $1,656,000 a. Prepare a variable costing income statement, assuming that the fixed manufacturing costs were $132,000 and the variable selling and administrative expenses were $115,200. In your computations, round unit costs to two decimal places and round final answers to the nearest dollar. Rhys Company Income Statement-Variable Costing For the Month Ended July 31 Sales V Variable cost of goods sold: Variable cost of goods manufactured…X Paste Clipboard FILE H5 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. 15 56 HOME A Calibri 의 INSERT BI U ▾ 11 12 13 14 Inventories: 1 9 Actual costs for the year: 10 READY ▾ Font 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 Raw materials (all direct) 16 Work in process 17 Finished goods 18 11 B с 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost PAGE LAYOUT Cost of Goods Manufactured and Cost of Goods Sold - Excel DATA REVIEW VIEW A A Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs fx 19 Use the data to answer the following. 20 Predetermined overhead rate Actual direct labor hours Sheet1 G FORMULAS % Alignment Number D Beginning $ $ $ Conditional Format as Cell Formatting Table Styles Styles E T $ 275,000 25,000…Details $ Units produced 1,000 Direct materials $8 Direct labour $12 Fixed production overhead $7,000 Variable production overhead $3 Fixed selling and administrative $3,000 Variable selling and administrative $5 a) Determine the unit product cost under absorption costing. b)