Analyze production and sales record in order to track key metrics, examine sales growth and give recommendations on ways to enhance sales performance and implementing efficient production techniques.

Cleaned and transformed data in Excel

Processed and analyzed data to develop insights that can help solve the business problem

Developed a dashboard using Power BI

Generated report to present findings to management

Printed rolls incurred the highest expenses in terms of production cost for December 2023

The first and third week recorded a high increase in sales at the rate of 81% and 54% respectively showing positive improvement in sales growth

The third week was the most productive as zero naira was spent on production while sales performance almost doubled the amount of the previous week

Weekly sales trend show that there was consistent increase in sales performance across the week, accounting for the 31% profit margin 📈 accumulated in December

Employ strategies to effectively minimize cost of production by setting a target for controlling cost in order to limit its growth within a predetermined sum

Maintenance of machine and other equipment, detecting potential problems and fixing them before it slows down production process

Labor Management: Providing healthy working conditions for employees and giving incentives to encourage them.

Inventory Management: Maintenance of production materials in order to reduce waste and ensuring there is no overuse of equipment to avoid unnecessary repairs.

Delivery Optimization: Ensuring that supply is carried out on schedule and delivery made on time in order to meet up with customer demands.