Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You need to show the Excel formulas. This is the most important thing! Thank you Salish Craft Beers provides the following information for the Malting

image text in transcribed

image text in transcribed

You need to show the Excel formulas. This is the most important thing!

Thank you

Salish Craft Beers provides the following information for the Malting Department for the month of August 2018: Units Costs Beginning Work-in-Process Inventory Started in Production in August Total to Account For Completed and Transferred to Packaging Department during August 26,000 26,000 21,000 54,000 * 54,000 ? Ending Work-in-Process Inventory, 30% complete for direct materials and 60% complete for conversion costs. Total Accounted For 5,000 26,000 54,000 * Includes $18,000 direct materials and $36,000 conversion costs. Requirements Complete a production cost report for the Malting Department for the month of August 2018 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process Inventory. Assume Salish Craft Beers uses the weighted average method. Excel Skills 1. Enter numbers into cells. 2. Create formulas. 3. Format the cells requiring dollar signs. 4. Format the cells requiring a single underline and cells requiring double underlines. SALIH CRAFT BEERS Production Cost Report - MALTING DEPARTMENT Month Ended August 31, 2018 Equivalent Units Physical Units Direct Materials Conversion Costs UNITS Units to account for: Beginning work-in-process Started in Production Total units to account for 26,000 26,000 Units accounted for: Completed and transferred out Ending work-in-process Total units accounted for 21,000 5,000 26,000 21,000 1,500 22,500 21,000 3,000 24,000 Direct Materials Conversion Costs Total Costs $ - $ - $ - COSTS Costs to account for: Beginning work-in-process Costs added during period Total costs to account for Divided by total EUP Cost per equivalent unit Costs accounted for: Completed and transferred out Ending work-in-process Total costs accounted for

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glencoe Accounting

Authors: McGraw-Hill

1st Edition

0021400881, 9780021400881

More Books

Students also viewed these Accounting questions

Question

Know how to find a consultant

Answered: 1 week ago