Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nina is considering producing earrings that she will mostly sell online. She will require specific materials for this product line. She hopes to start selling

Nina is considering producing earrings that she will mostly sell online. She will require specific materials for this product line. She hopes to start selling this line in January and has provided you with her expectations of sales in units (one pair of earrings). January 1200, February 1500, March 1600, April 1750. She needs 20 grams of silver and two pieces of sea glass for each set of earrings. Silver is priced at 81 cents per gram and sea glass is sourced at $5 per piece. She thinks it would be a good idea to have half of the finished goods ready at the end of one month for the next months sales. All materials are available without lag times. The earrings will incur a labour cost of $75 each and sell for $125 each. She doesnt predict any other significant costs at this stage. Required: a. Nina would like you to demonstrate how to budget for sales, labour, production (in units) and materials (in dollars). Prepare a production and materials budget for the silver earrings in Excel for the first three months of the year.

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

Step: 3

blur-text-image

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

Fundamentals Of Accounting Course 2

Authors: Claudia B. Gilbertson

9th Edition

053844827X, 9780538448277

More Books

Students also viewed these Accounting questions

Question

discuss the importance of ethical practice for the HR profession;

Answered: 1 week ago

Question

reference your work in a credible way.

Answered: 1 week ago

Question

read in a critically evaluative way;

Answered: 1 week ago